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

153 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
remnants103684(None) 
remnant9312641remnant_
pennants1037062pennants
recants93217092re_cants
reenacts1036992reenacts
regnant8312842regnant_
regrants9310012regrants
remands104914882rem_ands
remans84823002rem_an_s
remints95117292rem_ints
remnantal1142532remnantal
remontants1245042remontants
remounts1036372remounts
replants102811242replants
resonants946692resonants
revenants1246172revenants
ruminants1144912ruminants
tenants7311012te_nants
bemeans1148743bemean_s
bemoans1138253bemoan_s
bezants1877343be_zants
bezzants1843643bezzants
cements112714223cem_ents
decants103514443de_cants
demandants1443253demandants
demands114311413dem_ands
demasts1089223dem_asts
demeans1039723demean_s
dements103016623dem_ents
demounts1135473demounts
descants112910143descants
deviants1236733deviants
dominants1245953dominants
eluants737583_eluants
emanant9411093_emanant_
embanks15295703_embanks
enacts84012973_e_nacts
errants7410643_errants
gelants82611443ge_lants
gellants9308283gellants
gymnasts1442433gymnasts
lemans85316393lem_an_s
levants1037723le_vants
mediants11299493mediants
peasants1038263peasants
pedants10310113pe_dants
penangs10268373pe_nangs
pendants1139093pendants
pennant9312493pennant_
preenacts1345843preenacts
pregnant1149883pregnant_
radiants9259443radiants
rampant11312173rampant_
ramparts1245583ramparts
rants55935343r___ants
reactants1146623reactants
reacts83616603re__acts
readapts1145583readapts
reagents959623reagents
reanoints945363reanoints
rebaits9312573re_baits
reboant9315093reboant_
recanes93222263re_canes
recant83228683re_cant_
recasts93413533re_casts
recharts1337663recharts
recoats92616643recoa_ts
recounts1038773recounts
recreants1146623recreants
recusants1145103recusants
redacts10510943re_dacts
redans75421023re_dan_s
redbaits1135903redbaits
redrafts1235603redrafts
reenact9413013reenact_
reentrants1044663reentrants
refracts13137383refracts
refronts1137773refronts
regents83416543re_gents
regnancy1444773regnancy
regrafts1235303regrafts
regrant8317323regrant_
rehangs1137563re_hangs
reheats104513523rehea_ts
reimplants1483533reimplants
reinvents1246123reinvents
reknits1137073rekn_its
reknots1136783rekn_ots
relands85214883re_lands
relaxants1643243relaxants
relents74018503re_lents
reliant7319243reliant_
reloans7313133reloan_s
remails94714563rem_ails
remains94117913rem_ains
remakes134116173rem_akes
reman75730153rem_an__
remand95618963rem_an_d
remanent10311703remanent_
remanned11319353remanned
remaps105012873rem_a_ps
remarks13329983rem_arks
remate84428683rem_a_te
remates93827113rem_ates
remeets93712413rem_eets
remelts93511493rem_elts
remends105013033rem_ends
reminds104614793rem_inds
remint85329983rem_int_
remits85622943rem__its
remontant1148103remontant_
remount9512283remount_
renails74917263re_nails
renames92418053re_names
renests74014213re_nests
renins64526453re_nin_s
rennases848983rennases
rennets75212633re_nnets
rennins74013413rennin_s
rents55935183re___nts
repaints1038483repaints
repasts93611933re_pasts
repeats94316053repea_ts
repents93717623re_pents
replans92814943replan_s
replant93318533replant_
reprints1039903reprints
reptant92817073reptant_
rerents73319423re_rents
reseats74319583resea_ts
resents74221223re_sents
resonant8410813resonant_
restarts8310873restarts
retints74717013re_tints
retirants947323retirants
retracts101111313retracts
revenant11410283revenant_
reynards1244303reynards
rimlands1145243rimlands
romanos94311483rom_anos
romans84620243rom_an_s
romaunts1043693romaunts
ruminant1047863ruminant_
sealants82610743sealants
seawants11337973seawants
secants93413893se_cants
servants1138003servants
setenants945973setenants
sextants15287383sextants
sonants7511233_sonants
tenant6322473te_nant_
versants1137783versants
zenanas16286233ze_nanas

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.406440125.6
2DLD Change Limit1461621537.76318828.0
3Display Results1531530.0632428.6
 (SQL Overall)1786911538.23221706.9
 
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.