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

152 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
inflater114989(None) 
inflamer1356121inflamer
inflate10312311inflate_
inflated12410861inflated
inflaters1247541inflaters
inflates11512191inflates
inflator1158031inflator
deflater123211602deflater
idolater936862idolater
infecter13229152infecter
infester11239432infester
inflame1256962inflame_
inflamed1446032inflamed
inflamers1455212inflamers
inflames1377322inflames
inflators1257712inflators
inflicter1444452inflicter
inlayer1036932in_layer
animater101512393animater
anteater8311603anteater
conflate13311173conflate_
conflated1539333conflated
conflates14311133conflates
defeater122611663defeater
deflate113613943deflate_
deflated133412303deflated
deflaters13298703deflaters
deflates123013943deflates
deflator12328343deflator
dilater83515653_dilater
elater64724203__elater
enfetter1145353enfetter
enflame1236573enflame_
enflamed1455723enflamed
enflames1357043enflames
enslaver1144713enslaver
falter94519053__falter
feater95224053__feater
flaker134916173__flaker
flamer114919123__flamer
flatter103815963__flatter
flayer124713563__flayer
floater104413353__floater
fluter95316863__fluter
frater94520593__frater
idolaters1045713idolaters
idolator946243idolator
implanter1385363implanter
inaner62213543in__aner
incenter102212093incenter
inciter93113773in_citer
incliner1038513incliner
incloser10106733incloser
indenter92311443indenter
indicter1148143indicter
inditer83514233in_diter
infante101910883infante_
infantes11249633infantes
infare9313083inf_are_
infares10313023inf_ares
infected14229403infected
infecters14257583infecters
infector13478853infector
infer84215033inf___er
inferrer11217443inferrer
infested12249643infested
infesters12237713infesters
infighter1644273infighter
inflating13310443inflating
inflation12311093inflation
inflected1546053inflected
inflector1465353inflector
inflexed1944023inflexed
inflicted1545533inflicted
inflicters1543453inflicters
inflictor1444013inflictor
influxes1844343influxes
infolder1256433infolder
informer13227283informer
infracted1546363infracted
infractor1465943infractor
infrared1236193infrared
infuser10298323inf_user
ingate73018243in_gate_
ingates82716913in_gates
ingather1244783in_gather
ingrate8715123ingrate_
ingrates9514173ingrates
inhalator1245053inhalator
inhaler1068053in_haler
inlace82513043in_lace_
inlaced10239873in_laced
inlaces92512903in_laces
inlander937223in_lander
inlayers1135643in_layers
inlier63615363in_l_ier
inmate82917363in_mate_
inmates92715783in_mates
innate63917313in_nate_
inputter1034203inputter
insaner7310443in_saner
inserter82312133inserter
insetter8218593insetter
insister888783insister
insnarer865303insnarer
insolate8311893insolate_
insolated1039713insolated
insolates9311273insolates
instanter946243instanter
instate71616483instate_
instated91613343instated
instates81615833instates
insulate8312843insulate_
insulated10310713insulated
insulates9311843insulates
insulator948103insulator
insulter836883insulter
inter55028493in___ter
intimater111110583intimater
inulase739413inulase_
inulases838763inulases
invader11146453in_vader
inventer112410843inventer
inverter112411073inverter
inviter104112313in_viter
irater65218353i__rater
isolate7313923isolate_
isolated9410523isolated
isolates8613513isolates
isolator847533isolator
later54843923___later
minelayer1453503minelayer
neater64424313_n_eater
negater83711963_negater
pinfeather1851843pinfeather
plater84427693__plater
reflate103516263reflate_
reflated123514293reflated
reflates113115663reflates
reinflate12157403reinflate_
reinflated14146473reinflated
reinflates13137213reinflates
relater73723143_relater
slater64429183__slater
tinplate1047743tinplate_
tinplates1147773tinplates
unfetter1136753unfetter
unflawed1536123unflawed
unfluted1237173unfluted
uninflated1474763uninflated
violater1137253violater
zoolater1746093zoolater

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.406440125.6
2DLD Change Limit1461621527.51319454.5
3Display Results1521520.0632412.7
 (SQL Overall)1786911527.98222386.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.