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 “formerly” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

87 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
formerly164500(None) 
forcedly1744802forcedly
forgery14419302forger_y
forkedly1944322forkedly
formably1846662formably
formally1638242formally
former114221402former__
formers128217952former_s
orderly1135762_orderly
comely134213733co_me_ly
cormel103815603corme_l_
cormels113813373corme_ls
dormer94415903dormer__
dormered1255673dormered
dormers104313923dormer_s
farmer115017373farmer__
farmers124315263farmer_s
fatherly1745073fatherly
ferly115517353f___erly
fernery1335813ferner_y
firefly1635633fir_efly
firmer114712443firmer__
firmers124711443firmer_s
firmly1436663firm__ly
foamer114714313foamer__
foamers123812103foamer_s
foamily1546543foam_ily
foolery1336693fooler_y
foppery17385623fopper_y
forcer114917343forcer__
forcers124215713forcer_s
forcibly1843863forcibly
forebay1538133for_ebay
foreby1438633for_e_by
foremilk1744373foremilk
foreplay1645673for_eplay
foreran10311793for_eran
forerun1037653for_erun
forger104820773forger__
forgers115218183forger_s
forker134717903forker__
forkers144615783forker_s
forlornly1551683forlornly
formable1539503formable
formal113215203form_al_
formals123312893form_als
forme105225993forme___
formed125021173forme__d
formee113919943forme__e
formes114623713forme__s
formful1545183formful_
formlessly1842953formlessly
formol112910333form_ol_
formols12299413form_ols
formula1246293form_ula
formyl14276443form_yl_
formyls15235703form_yls
forwardly1942753forwardly
freely12310963f_r_eely
friarly13316213f_riarly
fromenty1645243fromenty
frozenly2343123frozenly
furmenty1645293furmenty
furmety1534813furme_ty
gorbelly1445473gorbelly
gorgedly1444003gorgedly
homely145313183ho_me_ly
horsefly1744883horsefly
informedly1952793informedly
loverly1346973lo_verly
motherly16346093motherly
normally1347883normally
northerly1543523northerly
ormer75218373_ormer__
ormers84316143_ormer_s
ornery938463_orner_y
orrery936783_orrer_y
overly122411363_o_verly
properly1546463properly
soberly1236943so_berly
somberly1544053somberly
sorcery1237033sorcer_y
sorely94618013sor_e_ly
summerly15275103summerly
unorderly1342963unorderly
wormer114514913wormer__
wormers124012573wormer_s

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.420425454.8
2DLD Change Limit146162877.14320462.3
3Display Results87870.0302900.0
 (SQL Overall)178691877.59323533.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.