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 “ignorers” 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
ignorers921524(None) 
ignorer8276101ignorer_
ignores8269001ignore_s
honorers1139262honorers
igniters9126232igniters
ignore7269062ignore__
ignored9226442ignore_d
ionomers1038502ionomers
snorers74313802_snorers
adorers84411733_adorers
agnomens1144893agnomens
annoyers1185033annoyers
armorers10288973armorers
borers85122683__borers
canoers94318373cano_ers
colorers10312183colorers
corers85231073__corers
favorers1465493favorers
figurers12254873fig_urers
fingerers13136303fingerers
floorers11227573floorers
gaolers83511563_gaolers
gingers94118643gin_gers
ginners84314223gin_ners
glovers114310883_glovers
glowers113412093_glowers
gnarrs7407663_gnar_rs
gnawers11356393_gnawers
gnomes93812973_gnome_s
gnoses76515163_gnose_s
goers65520253_g_o_ers
gofers104711513_g_ofers
gomers94116883_g_omers
goners74420173_g_oners
goobers10219623_goobers
gores65740373_g_ore_s
gorgers94813643_g_orgers
grocers103511253_grocers
gropers104813853_gropers
growers113612723_growers
honorees1148773honorees
honorer1039673honorer_
honourers1245573honourers
igniter8147673igniter_
ignites81310583ignite_s
ignitors9135513ignitors
ignorami1142863ignorami
ignoramus1241953ignoramus
ignorant947153ignorant
ignoring1036483ignoring
imbowers15295093imbowers
implorers13124413implorers
importers13247763importers
imposers12278463imposers
impowers15296823impowers
inbreds10245733i_nbreds
inchers123912523i_nchers
incomers1268593incomers
indorsers1075383indorsers
infers93615443i_n_fers
informers14206133informers
ingress838653i_ngress
injurers15286123injurers
inkers104018833i_n_kers
inliers73110743i_nliers
inners63919353i_n_ners
insnarers954433insnarers
insurers83710133insurers
inters64328053i_n_ters
intoners889933intoners
inures63318953i_nure_s
invokers1534673invokers
ionizers17257713ionizers
ionogens956823ionogens
ionomer939833ionomer_
ionones7313883ionone_s
ironers74813553i_roners
isomers9310043i_somers
knowers1436353_knowers
laborers10208383laborers
lingerers10126923lingerers
manurers1037593manurers
misnomers1346183misnomers
monomers12311033monomers
noters64021003__noters
runovers1134473runovers
savorers1157223savorers
scorers94115323_scorers
senores73218113senore_s
shnorrers1243533shnorrers
signalers1044583signalers
signers84714443sign__ers
signoras9306553signor_as
signore8329093signore__
signories10107853signories
signors83410913signo__rs
snarers74216663_snarers
snorer64316763_snorer_
snores64324323_snore_s
snorters83410583_snorters
storers75018683_storers
taborers10268333taborers
tenoners858713tenoners
vaporers1336243vaporers
venomers1336703venomers
wingovers1643553wingovers
winnowers1543953winnowers

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.436409841.7
2DLD Change Limit1461621077.53319402.9
3Display Results1071070.0432488.4
 (SQL Overall)1786911078.01222302.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.