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

109 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
inflaters124754(None) 
inflamers1455211inflamers
inflater1149891inflater_
inflates11512191inflate_s
inflators1257711inflators
deflaters13298702deflaters
idolaters1045712idolaters
infecters14257582infecters
infesters12237712infesters
inflamer1356122inflamer_
inflames1377322inflame_s
inflate10312312inflate__
inflated12410862inflate_d
inflator1158032inflator_
inflicters1543452inflicters
inlayers1135642in_layers
animaters11129973animaters
anteaters939343anteaters
conflates14311133conflate_s
defeaters13289103defeaters
deflater123211603deflater_
deflates123013943deflate_s
deflators13348153deflators
dilaters92513063_dilaters
elaters74420193__elaters
enfetters1244463enfetters
enflames1357043enflame_s
enslavers1243883enslavers
falters103916473__falters
flakers143613273__flakers
flamers124616363__flamers
flatters113814203__flatters
flayers133912033__flayers
floaters112711513__floaters
fluters103713683__fluters
fraters103517213__fraters
idolater936863idolater_
idolators1046283idolators
implanters1484153implanters
incenters112510303incenters
inciters103210673in_citers
incliners1146333incliners
inclosers11155563inclosers
indenters102710033indenters
indicters1236733indicters
inditers93311053in_diters
infantes11249633infante_s
infares10313023inf_are_s
infecter13229153infecter_
infectors14218553infectors
inferrers12226583inferrers
infers93615443inf___ers
infester11239433infester_
infighters1743323infighters
inflame1256963inflame__
inflamed1446033inflame_d
inflating13310443inflating
inflation12311093inflation
inflations13310323inflations
inflectors1545213inflectors
inflicter1444453inflicter_
inflictors1543953inflictors
influxes1844343influxe_s
infolders1385173infolders
informers14206133informers
infractors1566003infractors
infrareds1342583infrareds
infusers11286143inf_users
ingates82716913in_gate_s
ingathers1344453in_gathers
ingrates9514173ingrate_s
inhalators1344933inhalators
inhalers1166643in_halers
inlaces92512903in_lace_s
inlanders1036143in_landers
inlayer1036933in_layer_
inliers73110743in_l_iers
inmates92715783in_mate_s
inputters1143443inputters
inserters92210283inserters
insetters9187133insetters
insisters997653insisters
insnarers954433insnarers
insolates9311273insolate_s
instates81615833instate_s
insulates9311843insulate_s
insulators1047263insulators
insulters945883insulters
inters64328053in___ters
intimaters1297853intimaters
inulases838763inulase_s
invaders12105303in_vaders
inventers12269533inventers
inverters12239753inverters
inviters11359643in_viters
isolates8613513isolate_s
isolators947513isolators
minelayers1543453minelayers
negaters9349783_negaters
pinfeathers1951793pinfeathers
platers93924093__platers
reflates113115663reflate_s
reinflates13137213reinflate_s
relaters83218153_relaters
slaters73123733__slaters
tinplates1147773tinplate_s
unfetters1244363unfetters
violaters1245963violaters
zoolaters1844983zoolaters

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.1701051123.5
2DLD Change Limit1486411097.37620152.0
3Display Results1091090.0462369.6
 (SQL Overall)1786911097.59223536.7
 
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.