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

214 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
regrants931001(None) 
regrafts1235301regrafts
regrant8317321regrant_
errants7410642_errants
grants73722472__grants
migrants1138182migrants
recants93217092re_cants
recreants1146622recreants
redrafts1235602redrafts
refracts13137382refracts
refronts1137772refronts
regents83416542reg_ents
regnant8312842regnant_
regrades103212172regrades
regraft11310152regraft_
regranted1137702regranted
regrate82618662regra_te
regrates92618402regrates
regreets9287852regreets
regrets83212922regr_ets
regrinds1035532regrinds
remnants1036842remnants
replants102811242replants
reprints1039902reprints
rerents73319422re_rents
retirants947322retirants
retracts101111312retracts
vagrants1246142vagrants
aberrants1145853aberrants
begroans1145503begroan_s
bezants1877343be_zants
bezzants1843643bezzants
brants85723053__brants
courants10310803courants
currants1037933currants
decants103514443de_cants
degrades11269923degrades
derats74625063de_ra_ts
descants112910143descants
detracts11138833detracts
deviants1236733deviants
egrets72712243_egr_ets
eluants737583_eluants
emigrants1244733emigrants
engrafts1294703engrafts
entrants8311753entrants
errands847603_errands
errant6618733_errant_
figurants1343973figurants
fragrant1247113fragrant_
gelants82611443ge_lants
gellants9308283gellants
gerents82612923ge_rents
giants74713503__giants
grafts105013253__grafts
grands84218243__grands
grans64832543__gran_s
grant64840023__grant_
grunts75511853__grunts
hydrants1585793hydrants
ingrafts12105803ingrafts
integrants1146693integrants
intrants8312863intrants
jurants14379213_jurants
levants1037723le_vants
mediants11299493mediants
migrant10314313migrant_
negronis947263negronis
odorants946043odorants
operants1039483operants
oreganos945553oreg_anos
pageants1136693pageants
peasants1038263peasants
pedants10310113pe_dants
pendants1139093pendants
pennants1037063pennants
prefranks1862993prefranks
pregnant1149883pregnant_
preprints1347473preprints
radiants9259443radiants
raglans82410133raglan_s
rants55935343___rants
reactants1146623reactants
reacts83616603re__acts
readapts1145583readapts
reagents959623reagents
rebaits9312573re_baits
reboant9315093reboant_
rebranch1545803rebranch
recanes93222263re_canes
recant83228683re_cant_
recasts93413533re_casts
recharts1337663recharts
recoats92616643recoa_ts
recounts1038773recounts
recrate92621663recra_te
recrates102420373recrates
recreant10311283recreant_
recruits1036563recruits
recusants1145103recusants
redacts10510943re_dacts
redans75421023re_dan_s
redbaits1135903redbaits
redraft11310573redraft_
redraws11218473redra_ws
redroots937753redroots
reearns749103reearn_s
reenacts1036993reenacts
reentrants1044663reentrants
reerects10319923reerects
referents12259643referents
refract121311603refract_
refrains1139593refrains
reframes1338993reframes
refront10313263refront_
regains84316583reg_ains
regales83520793reg_ales
regardant1145443regardant_
regards94112563reg_ards
regatta835963reg_atta
regattas944473reg_attas
regears83012463regea_rs
regent74127673reg_ent_
reggaes948883regga_es
regiments123910323regiments
reginas85614063reg_inas
regions83613473region_s
registrants1253063registrants
reglazes1846793reglazes
reglets83512983reg_lets
regmata1036193regma_ta
regnancy1444773regnancy
regrade92612033regra_de
regraded113410763regraded
regrafted1435243regrafted
regranting1238323regranting
regrated102816333regrated
regreens9257453regreens
regreet83015953regreet_
regress82711453regr_ess
regret73723533regr_et_
regrind938983regrin_d
regrooms1196013regrooms
regroups11104383regroups
regrows11269153regr_ows
regrowth1544033regrowth
regrowths1642433regrowths
rehangs1137563re_hangs
reheats104513523rehea_ts
relands85214883re_lands
relaxants1643243relaxants
relents74018503re_lents
reliant7319243reliant_
reloans7313133reloan_s
remands104914883re_mands
remans84823003re_man_s
remints95117293re_mints
remnant9312643remnant_
remounts1036373remounts
rents55935183re___nts
reorients997363reorients
repaints1038483repaints
repasts93611933re_pasts
repeats94316053repea_ts
repents93717623re_pents
replans92814943replan_s
replant93318533replant_
reprint9318983reprint_
reptant92817073reptant_
reracks132310533re_racks
reran57329103re_ran__
rerent63832453re_rent_
reruns66413743re_run_s
reseats74319583resea_ts
resents74221223re_sents
resonants946693resonants
restarts8310873restarts
restraints1056603restraints
retardants1144143retardants
retints74717013re_tints
retirant8313593retirant_
retraces101417273retraces
retracks14149103retracks
retract91318113retract_
retrains8314533retrains
retreats8311413retreats
retroacts1146283retroacts
revenants1246173revenants
revertants13124953revertants
rewraps12136563rewra_ps
rewrapt12138113rewrapt_
roborants1145053roborants
ryegrass1242793ryegra_ss
sealants82610743sealants
seawants11337973seawants
secants93413893se_cants
segments1138903segments
segregants1242703segregants
sergeants10115593sergeants
serranos857873serranos
servants1138003servants
sextants15287383sextants
spirants1088283spirants
taggants1044933taggants
tenants7311013te_nants
terranes82514433terranes
titrants838483titrants
tyrants1037453_tyrants
vagrant11410663vagrant_
vegans103910853veg_an_s
versants1137783versants
vibrants1345913vibrants
warrants1168503warrants
zebranos1943713zebranos

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.440406115.9
2DLD Change Limit1461622147.07620656.0
3Display Results2142140.0762815.8
 (SQL Overall)1786912147.59223536.7
 
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.