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 “instituters” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
instituters115323(None) 
instituter1044511instituter_
institutes1046051institute_s
institutors1153211institutors
institute946442institute__
instituted1144942institute_d
institutor1053672institutor_
constitutes1376163constitute_s
destitutes1156523destitute_s
insetters9187133ins_et_ters
insisters997653ins_i_sters
instigates1148423instigate_s
instigators1245923instigators
instillers1043663insti_llers
instituting1244803instituting
institution1145293institution
institutions1244733institutions
intimaters1297853in_timaters
intitules966783in_titule_s
reinstitutes1253263reinstitute_s
restitutes1057833restitute_s
antibusers1244444an_tibusers
antinukers1443884an_tinukers
antiquers1845804an_tiqu_ers
antitrusters1252024an_titrusters
antitumors1253754an_titumors
constitute1276704constitute__
constituted1475054constitute_d
destitute1046884destitute__
destituted1255254destitute_d
enstatites1044524enstatite_s
hesitaters1374854hes_itaters
imbitters13274504i_mbit_ters
inaptitudes1462814inaptitude_s
inciters103210674in_ci__ters
indicters1236734in_di_cters
inditers93311054in_di__ters
ineptitudes1463084ineptitude_s
infighters1743324in_fighters
inflicters1543454infli_cters
inhibiters1543694in_hibiters
initialers1053044initi_alers
initiates9411184initi_ate_s
initiators10127314initi_ators
inputters1143444in_put_ters
inserters92210284ins__erters
insetter8218594ins_et_ter_
insiders947764ins_i__ders
insinuates1045464ins_inuate_s
insinuators1154144ins_inuators
insister888784ins_i_ster_
inspirators1345554inspirators
inspirers1143964inspi__rers
installers1043634inst_allers
instanter946244inst_anter_
instates81615834ins__tate_s
instigate1048614instigate__
instigated1247694instigate_d
instigator1146414instigator_
instiller944954insti_ller_
instincts1144534instinct__s
instructors1355384instructors
insulters945884ins__ulters
insurers83710134ins___urers
intimater111110584in_timater_
intimates111013314in_timate_s
intitles8710004in_tit_le_s
intitule867424in_titule__
intituled1064514in_titule_d
intriguers1143334intrigu_ers
intruders1044744in_t_ruders
investitures1572594investiture_s
inviters11359644in_vi__ters
knitters12336624kn__it_ters
nictitates1244954nictitate_s
pinsetters1244104pins_et_ters
pinspotters1551834pinspot_ters
prostitutes1345174prostitute_s
prostitutors1452914prostitutors
reinstitute1153604reinstitute__
reinstituted1353124reinstitute_d
restitute947754restitute__
restituted1156534restitute_d
sitters74221554__s_it_ters
skitters12349554__skit_ters
slitters84014134__slit_ters
spitters104113384__spit_ters
statutes8368894__statute_s
stinters83312764__sti_nters
stitchers14147014__stitchers
strutters955704__strutters
stutters83210474__stut_ters
substitutes1354354substitute_s
titters74219624___tit_ters
unstitches1543564unstitche_s
vastitudes1444324vastitude_s

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit148819968.51617475.2
3Display Results96960.0462087.0
 (SQL Overall)178691968.98519887.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.