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

190 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
entrant731887(None) 
entrants8311751entrants
intrant7318751intrant
enchant12313112enchant
engraft11118612engraft
enrapt8313012en_rapt
entrain7313072entrain
entrains8312962entrains
entrance10311332entrance
entrap8710562entra_p
entraps9109762entraps
entreat7315262entreat
entrust7410882entrust
errant6618732e_rrant
extant132714752ext_ant
extract16311012extract
extranet15412992extranet
intranet8418442intranet
intrants8312862intrants
penetrant1148462penetrant
reentrant947832reentrant
titrant7315192titrant
alterant8614963alterant
antra56521923antra__
antral65719413antra_l
anuran64313243anuran_
anurans73810553anurans
arrant6623253_arrant
attract9511833attract
brant74742173__brant
centra84113883centra__
central93114473centra_l
centrals102712033centrals
centring112112953centring
centrist10314863centrist
contract122915633contract
contrast102614783contrast
courant9317973courant
currant9314173currant
denaturant1154503denaturant
detract101414633detract
dextran1586163dextran_
dextrans1695983dextrans
elegant8311503elegant
eluant6315093e_luant
emanant9411083emanant
emigrant1148553emigrant
enact73525363en__act
enchants1347823enchants
encrust947873encrust
encrypt1445323encrypt
endrin7312403endrin_
endrins8312163endrins
enframe1247363enframe
engrafts1294703engrafts
engrail846263engrail
engrain838353engrain
engrains937583engrains
engram9310653engra_m
engrams1038073engrams
engrave1137133engrave
enplane939723enplane
enrage72715073en_rage
enroot6615993en_root
entail61114343ent_ail
entente7412953ent_ente
entera64216833entera__
enteral73516443entera_l
entering91920053entering
enteron7313333enteron_
enterons8314153enterons
enthral103410933enthra_l
enthrall11266833enthrall
enthrals11278903enthrals
enthrone111110113enthrone
entia5318203entia__
entrails8310163entrails
entrained1089413entrained
entrainer968583entrainer
entranced1247393entranced
entrances11310953entrances
entrapment1447883entrapment
entreats839773entreats
entreaty1146173entreaty
entree61817883entr_ee
entrees71813773entrees
entrench13115723entrench
entrepot1046193entrepot
entries71523163entries
entropy1247353entropy
entrusts847113entrusts
entry82414263entr__y
entwine1039143entwine
entwist1048803entwist
enuring8813883enuring
enwrap1185213enwra_p
enwraps1284833enwraps
errand758793e_rrand
errants7410643e_rrants
estral64716513estra_l
estrange9488893estrange
estray95713333estra_y
estrays10529403estrays
estreat7314813estreat
estrin6315923estrin_
estrins7315853estrins
estrone7413953estrone
etchant1249813etchant
ethane94613243e_thane
explant16310133explant
extent132714913ext_ent
extra1239003extra__
extracts1747623extracts
extranets1646363extranets
extras13310223extra_s
gentian8310103gentian_
gentians937563gentians
grant64840023__grant
hydrant1489053hydrant
ignorant947153ignorant
incant82418503in_cant
indraft1199563indraft
inerrant8412493inerrant
infant92315133in_fant
infract12610003infract
ingraft1199493ingraft
instant7815343instant
insurant8411423insurant
intact8314663int_act
integrant1049833integrant
intent63122773int_ent
interact10316473interact
intranets949263intranets
intreat7416303intreat
intrigant1047683intrigant
introit7414533introit
intron64215023intron_
introns73515023introns
intrust7311493intrust
iterant7317783iterant
jurant134216553_jurant
migrant10314313migrant
mutant8317693mut_ant
natant6318733_natant
nutant6316383_nutant
octant81216553oct_ant
odorant8411393odorant
operant9317223operant
outran63218893outran_
outrang83813953outrang
outrank112611973outrank
penchant1549573penchant
pendant10314853pen_dant
penetrants1245273penetrants
pennant9312493pen_nant
pentane9415743pent_ane
rant45864683___rant
reentrants1044663reentrants
regrant8317323regrant
reptant92817073rept_ant
restraint9412753restraint
retirant8313593retirant
retract91318113retract
saturant8410643saturant
sentient8313633sentient
sextant142911963sext_ant
sonorant8411703sonorant
spirant9814293spirant
strait64025893_strait
strand74514823_strand
strang75718313_strang
strunt64918913_strunt
tenant6322473ten__ant
titrants838483titrants
tract75635713__tract
trait56940843__trait
trank96222423__trank
tranq145416893__tranq
trans54933043__trans
trapt76433393__trapt
truant6315783__truant
tyrant9315333_tyrant
unmeant9510903unmeant
unrent63219783un_rent
untrack1338703untrack
vagrant11410663vagrant
ventral103612173ventra_l
ventrals112910003ventrals
vibrant12410393vibrant
warrant10614243warrant

Search took 7 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 Filter1786911340270.423422437.4
2DLD Change Limit1340271905.92322628.2
3Display Results1901900.0762500.0
 (SQL Overall)1786911906.42227824.8
 
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.