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 “gilberts” 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.

107 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
gilberts113418(None) 
filberts1334991filberts
gilbert10310761gilbert_
filbert12411642filbert_
gibbers124710982gibber_s
gibbets12417722gibbe_ts
gibers95114662gi_ber_s
giblets103210422gible_ts
gilders94212462gilder_s
gillers84216902giller_s
halberts1335972halberts
ailments1039433ailments
alerts64418223_al_erts
bibbers103911353bibber_s
bilberry1543283bilberry
bilkers134711863bilker_s
billers94720833biller_s
billets94516153bille_ts
culverts13295323culverts
dibbers124013173dibber_s
diluents946053diluents
disserts92411813disserts
diverts114412033di_verts
fibbers144510603fibber_s
fibers114717523fi_ber_s
filers94623723fil_er_s
filets94718953fil_e_ts
fillers104320213filler_s
fillets103414753fille_ts
filmers124211293filmer_s
filters103816553filter_s
gabbarts1344063gabbarts
gabbers124612833gabber_s
galeres83514333gal_eres
gallets83517403galle_ts
gelders93812573gelder_s
gerberas1144963gerberas
gibber114112863gibber__
gibbered1444303gibbered
gibberish1742583gibberish
gibbet114113383gibbe_t_
giber85417703gi_ber__
gibes84422523gi_be__s
giblet93418893gible_t_
giglets93211553gigle_ts
gilder84415533gilder__
giller74519733giller__
gillnets934733gillnets
gilts64924263gil___ts
gimlets10338433gimle_ts
gingers94118643ginger_s
ginners84314223ginner_s
gippers123212083gipper_s
girders9379943girder_s
girts65423623gi___rts
gitterns9326573gitterns
givers104817713gi_ver_s
gleets75315053g_l_eets
gliders94811843glider_s
gluers75011153g_luer_s
gobbets12327643gobbe_ts
goblets103210183goble_ts
golfers114410083golfer_s
goobers10219623goober_s
grillers93810813griller_s
guilders1035513guilder_s
gullets84013713gulle_ts
gulpers10299013gulper_s
halberds1435183halberds
halbert12314503halbert_
hillers103718733hiller_s
inerts64517023_i_nerts
inserts74013993_inserts
inverts103211953_inverts
jibbers18449703jibber_s
jibers155912883ji_ber_s
jilters144211963jilter_s
killers114215583killer_s
kilters113813603kilter_s
lamberts12348793lamberts
libbers113812833libber_s
libers84721443li_ber_s
liberty1237163li_berty
limbers113614743limber_s
milers84625163mil_er_s
milkers134411613milker_s
millers93621343miller_s
millets94216843mille_ts
milters93619093milter_s
oilbirds1143183oilbirds
oilers64721193oil_er_s
pilfers1238963pilfer_s
ribbers113913183ribber_s
riblets93412553rible_ts
rillets74216153rille_ts
sieverts1145713sieverts
silents73514493sil_ents
sillers73822103siller_s
silvers104714043silver_s
tilers63523503til_er_s
tillers73418743tiller_s
tilters73315953tilter_s
timbers113111853timber_s
wilders113513503wilder_s
willers103517913willer_s
willets104414323wille_ts
zibets1737743zi_be_ts

Search took 8 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.1561145455.1
2DLD Change Limit1461621077.20320291.8
3Display Results1071070.0303566.7
 (SQL Overall)1786911077.38924183.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.