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

66 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
romaunts104369(None) 
romaunt947801romaunt_
remounts1036372remounts
romaines10512522romaines
romanos94311482roma_nos
romans84620242roma_n_s
amounts937043_amounts
aunts55227633___aunts
chaunts1267083_chaunts
combusts1445503combusts
comments142913883comments
communes143411243communes
counts84618273co__unts
daunts75014083__daunts
demounts1135473demounts
domaines11611063domaines
domains10510873domain_s
dopants1038433dopa_nts
flaunts1056133_flaunts
foments122912053fom_ents
formants13269953forma_nts
founts94313383fo__unts
foxhunts2141993foxhunts
haunts95614393__haunts
jaunts137511883__jaunts
loments93413473lom_ents
maunds9519653__maunds
mauts75927193__mau_ts
moments113113123mom_ents
mounts84115073__mounts
rants55935343r__a_nts
recants93217093reca_nts
recounts1038773recounts
remains94117913remain_s
remands104914883rema_nds
remans84823003rema_n_s
remints95117303rem_ints
remnants1036843remnants
remount9512283remount_
repaints1038483repaints
roans54926443ro_a_n_s
roasts64915413ro_a_sts
robands10219863roba_nds
rodents8611543ro_dents
romaine9512123romain_e
romajis1635913roma_jis
roman75424823roma_n__
romance11311083roma_nce
romances12310793romances
romanise10312133roma_nise
romano84912943roma_n_o
romantic1249243roma_ntic
romantics1346783roma_ntics
roquets16398943ro_quets
rotguts833763rotgu_ts
rounds73615623ro__unds
rousts617016723ro__usts
routs57133413ro__u_ts
rowans95715343rowa_n_s
runts55927633r___unts
somans84619303soma_n_s
sonants7511233sona_nts
taunts65715663__taunts
tomans85419133toma_n_s
vaunts95212623__vaunts
womans114613653woma_n_s

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.440406115.9
2DLD Change Limit146162667.67019056.3
3Display Results66660.0164125.0
 (SQL Overall)178691668.12621990.0
 
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.