Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “gimbaled” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

110 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
gimbaled1410417(None) 
gimballed1542671gimballed
gambled134112162gamb_led
gamboled1435872gamboled
gimbal11228812gimbal__
gimbals12257822gimbal_s
imbalmed1543292_imbalmed
impaled12288512_impaled
timbale11248802timbale_
timbales12227842timbales
wimbled15298152wimb_led
ambled115116373_amb_led
baled85436443___baled
bumbled144113043bumb_led
cimbalom1642443cimbalom
combated1539823combated
cymbaler1743113cymbaler
dialed84716453di__aled
dibbled133510843di_bbled
dimpled132810303dim_pled
disabled1248713disabled
embalmed1544263_embalmed
embayed1535443_embayed
empaled12288953_empaled
fimble133611753fimb_le_
fimbles143510663fimb_les
finialed1255503finialed
fumbled153710493fumb_led
gabbled134112453g_abbled
gabled105518453g_ab_led
gambade1336383gambade_
gambades1435863gambades
gamble115417183gamb_le_
gambler123612683gamb_ler
gambles124016203gamb_les
gambolled1543103gambolled
garbled114512803garb_led
gemmated14336293gemmated
gibbed124512353gi_b_bed
gibbered1444303gibbered
gibbeted1492783gibbeted
gibed96215963gi_b__ed
giblet93418893gi_b_let
giggled114010073gi_ggled
gilled84521633gi__lled
gimbaling15134443gimbaling
gimlet93716663gim__let
gimleted1243973gimleted
gimmal11247513gimmal__
gimmals12225823gimmal_s
gimped123911473gim__ped
girdled10217453gi_rdled
globated1265753globated
goaled85014363g__oaled
gobbled134010253g_obbled
grabbled14327373grabbled
grimaced1463313grim_aced
grumbled14256753grumb_led
gumball1266833gumbal_l
gumballs1345313gumballs
humbled153711813humb_led
imaged1097763_im_aged
imbalm1246323_imbal_m
imbalmer1443193_imbalmer
imbalms1334553_imbalms
imbarked17254063_imbarked
imbed105013653_imb__ed
imbibed1433733_imbibed
imblazed2243763_imblazed
imbrued1234693_imbrued
imbued1136173_imb_ued
impale102811663_impale_
impaler11298393_impaler
impales113311763_impales
impled113812513_im_pled
inhaled1169333_inhaled
jumbled19379963jumb_led
kibbled16367983ki_bbled
libeled10249413li_beled
limbate1139213limbate_
limbed114513183limb__ed
limbered13158123limbered
mumbled143010763mumb_led
nibbled12389073ni_bbled
nimble103412943nimb_le_
nimbler11358063nimb_ler
nimbused1343013nimbused
piebald1245503piebal_d
pimpled14289183pim_pled
pinballed1444033pinballed
rambled123913523ramb_led
ribald9209293ri_bal_d
rimpled123311423rim_pled
rivaled1138933ri_valed
rumbaed12287493rumba_ed
rumbled124514593rumb_led
sambaed1238303samba_ed
signaled1035393signaled
symboled1644493symboled
timbal102510753timbal__
timbals11239533timbal_s
timbered13137383timbered
tumbled123412243tumb_led
umbeled12208193_umbeled
unbaled103315963_unbaled
vialed105112593vi__aled
wambled153610753wamb_led
wimble133211923wimb_le_
wimbles143010853wimb_les
wimpled15338823wim_pled

Search took 9 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.1731032896.0
2DLD Change Limit1461621108.76316679.4
3Display Results1101100.0462391.3
 (SQL Overall)1786911108.98219894.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.