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

113 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
informer1322728(None) 
informed14197671informed
informers14206131informers
conformer1667462conformer
deformer14247942deformer
enforcer13246502enforcer
former114221402__former
incomer1169942inco_mer
indorser985712indorser
inferrer11217442inferrer
infirmed14205342infirmed
inflamer1356122inflamer
infolder1256432infolder
inform11310152inform__
informal1355642informal
informs1248072inform_s
reformer13217952reformer
unformed14239572unformed
uniformer1443632uniformer
affirmer1643083affirmer
biformed1643693biformed
confirmer1665663confirmer
conformed1767463conformed
conformers1746553conformers
defoamer14276213defoamer
deforcer14246903deforcer
deformed15248263deformed
deformers15266533deformers
dewormer14256323dewormer
dormer94415903__dormer
endorser966733endorser
enfolder1286153enfolder
enforce12237423enforce_
enforced14216743enforced
enforcers14215213enforcers
enforces13208013enforces
farmer115017373__farmer
firmer114712443__firmer
foamer114714313__foamer
forcer114917343__forcer
forger104820773__forger
forker134717903__forker
forme105225993__forme_
formed125021173__formed
formee113919943__formee
formers128217953__formers
formes114623713__formes
ignorer8276103ignor_er
importer12308913importer
inarmed10268673in_armed
income10712093inco_me_
incomers1268593inco_mers
incomes11712373inco_mes
indorse8108193indorse_
indorsed1066123indorsed
indorsee977443indorsee
indorsers1075383indorsers
indorses968063indorses
indorsor953203indorsor
infare9313083infar_e_
infares10313023infar_es
infecter13229153infecter
infer84215033inf___er
inferior1156423inferior
inferred12248353inferred
inferrers12226583inferrers
infester11239433infester
infirm1137043infirm__
infirmary1752353infirmary
infirmly1643083infirmly
infirms1245563infirm_s
inflame1256963inflame_
inflamed1446033inflamed
inflamers1455213inflamers
inflames1377323inflames
inflater1149893inflater
infolded1375663infolded
infolders1385173infolders
informant1446473informant
informedly1952793informedly
informing1537023informing
infuser10298323inf_user
inholder1276113inholder
inhumer1275383in_humer
injurer14318473injur_er
inserter82312133inserter
insurer73312803insur_er
intoner7811673into_ner
intorted9310123intorted
inverter112411073inverter
invoker1435363invo_ker
involver1444663involver
ionomer939833iono_mer
isomer8310153i_so_mer
misformed1745243misformed
nonfarmer1444623nonfarmer
normed95014543_n_ormed
ormer75218373___ormer
performer16145133performer
reformed14249603reformed
reformers14246403reformers
reinforcer1553403reinforcer
reinformed1664333reinformed
snorer64316763sn_or_er
snorter74412663sn_orter
unfolder12216583unfolder
unforced14239133unforced
unforged13238623unforged
unforked16218953unforked
uniformed1544533uniformed
uninformed1643653uninformed
winsomer1345773winso_mer
wormer114514913__wormer

Search took 7 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.423422437.4
2DLD Change Limit1461621136.42322756.0
3Display Results1131130.0462456.5
 (SQL Overall)1786911136.89225927.3
 
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.