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

137 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
inserters9221028(None) 
inserter82312131inserter_
insetters9187131insetters
inverters12239751inverters
asserters956392asserters
deserters10129982deserters
incenters112510302incenters
indenters102710032indenters
infecters14257582infecters
inferrers12226582inferrers
infesters12237712infesters
inserted92413052inserte_d
inserts74013992insert__s
insetter8218592insetter_
insisters997652insisters
insulters945882insulters
insurers83710132insur_ers
interterm1148812interterm
inventers12269532inventers
inverter112411072inverter_
invertors12239792invertors
pinsetters1244102pinsetters
absenters1156173absenters
answerers1243743answer_ers
anteaters939343anteaters
assenters966993assenters
asserter877573asserter_
assertors965973assertors
assorters965733assorters
averters11249513_averters
besetters11136643besetters
consenters12410843consenters
conservers1547683conservers
converters1539633converters
deserter91211603deserter_
deservers13107293deservers
dissenters1197723dissenters
diverters13227873diverters
enfetters1244463enfetters
ensurers8279373ensur_ers
enterers82214153enter_ers
fingerers13136303finger_ers
hinderers1337353hinder_ers
imparters13276573imparters
importers13247763importers
incenter102212093incenter_
inceptors1345773inceptors
inciters103210673in_citers
indenter92311443indenter_
indentors10278313indentors
indexers16326373inde_xers
indicters1236733indicters
inditers93311053in_diters
indorsers1075383indorsers
inertias8410383in_ertias
inertness947973in_ertness
inerts64517023in_ert__s
infecter13229153infecter_
infectors14218553infectors
inferiors1266543inferiors
inferrer11217443inferrer_
infester11239433infester_
inflaters1247543inflaters
informers14206133informers
inheres10315173inher_e_s
inheritors1345633inheritors
injectors18216723injectors
injurers15286123injur_ers
innerness946913innerness
innerves1158013innerve_s
inputters1143443inputters
inscribers1442643inscribers
insectary1444213insectary
insects93710843insect__s
inselberg1241843inselberg
inselbergs1351233inselbergs
insert64325253insert___
inserting10914243inserting
insertion9410593insertion
insertions10410343insertions
insets64016133inse_t__s
insetted9249023insette_d
insiders947763ins_iders
insister888783insister_
insnarers954433insnarers
inspectors1444933inspectors
inspirers1143963inspirers
instars7411133ins__tars
instates81615833instate_s
insteps936573ins__teps
insulter836883insulter_
insureds9277613insur_eds
insurer73312803insur_er_
insures73117263insur_e_s
integers937783inte_gers
intenders10219373intenders
interbeds12238903interbeds
interfere12410813interfere
interferes1349983interferes
interiors9513563interiors
internees93014843internees
internes82721233interne_s
inters64328053in___ters
interties9320333interties
inventer112410843inventer_
inventors12288253inventors
inverness1247133inverness
inverses112410983inverse_s
inverted122312163inverte_d
invertins12911023invertins
invertor11238973invertor_
inverts103211953invert__s
investors12227723investors
inviters11359643in_viters
lingerers10126923linger_ers
minsters103813923mins__ters
misenters1139533misenters
nesters74422793_n_esters
netters73618583_n_etters
neuters74212273_n_euters
observers1443973observers
pinsetter1145013pinsetter_
reservers12138103reservers
resetters9129463resetters
resorters939693resorters
reverters122710433reverters
seaters74028943__seaters
sergers83815633__sergers
servers103214833__servers
setters73822063__setters
sneerers8309803sneer_ers
snorters83410583sn_orters
sorters74221133__sorters
tinkerers1395423tinker_ers
unfetters1244363unfetters
upsetters1143653upsetters
winterers12209723winter_ers

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411376.51322822.2
3Display Results1371370.0632174.6
 (SQL Overall)1786911376.99925530.9
 
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.