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 “roqueting” 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
roqueting194460(None) 
croqueting2243171croqueting
coquetting2244512coquetting
requesting2046312requesting
requiting1939882requiting
rocketing1666972rocketing
rogueing1054312rogue_ing
rousting93913272ro_usting
routing83821092ro_u_ting
banqueting2243123banqueting
bonneting1236173bonneting
briquetting2351743briquetting
coequating2245313coequating
colleting12311053colleting
competing163712463competing
conquering2246263conquering
corseting12312173corseting
cosseting1239543cosseting
counting113115263co_unting
courting112514563co_urting
coveting141912303co_veting
crocheting1844703crocheting
docketing1785413docketing
doubting1237373do_ubting
dueting93814393__dueting
equating18310113_equating
frequenting2443273frequenting
grommeting1642913grommeting
grouting103410793gro_u_ting
inquieting2044523inquieting
jousting16309353jo_usting
liquating1946313liquating
louting83719383lo_u_ting
moulting112710313mo_ulting
mounting112711813mo_unting
ousting84021353_o_usting
outing74128153_o_u_ting
parqueting2243633parqueting
pocketing1875853pocketing
pouting103519943po_u_ting
questing1838273__questing
queuing1736233__queuing
quieting18228463__quieting
quoting17310043__quoting
rabbeting1445183rabbeting
racheting1537793racheting
racketing1647873racketing
rebutting1237523rebutting
recutting1239483recutting
refueling13227973refueling
refuting121911903refu_ting
relucting1239773relucting
remeeting12311433remeeting
reputing112412603repu_ting
requiring1937043requiring
resulting10311083resulting
riveting12139443r_iveting
roasting93012693ro_asting
rodeoing1037253ro_deoing
rogering10310273ro_gering
roguing9309563rogu__ing
roosting93411453ro_osting
rooting83522433ro__oting
roquet154415893roquet___
roqueted1834653roquet_ed
roquets16398943roquet__s
roquette1755533roquet_te
roquettes1855063roquettes
rotating92614553ro_tating
rotting82919683ro__tting
roughing13278343ro_ughing
rouging93114703ro_u_ging
rouletting1144753rouletting
rounding102812283ro_unding
rouping103715793ro_u_ping
rousing83920553ro_u_sing
routine72615903ro_u_tine
roweling122811123ro_weling
russeting1065323russeting
rusting83821263r__usting
rutting82718043r__utting
socketing1666383socketing
sonneting1037003sonneting
toileting1036263toileting
touting84118453to_u_ting
unquoting1944763unquoting
vogueing1332233vogue_ing

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 Limit148641877.61019532.3
3Display Results87870.0461891.3
 (SQL Overall)178691877.82622833.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.