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

155 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
entrants831175(None) 
entrant7318871entrant_
intrants8312861intrants
enchants1347832enchants
engrafts1294702engrafts
entrails8310162entrails
entrains8312962entrains
entrance10311332entrance
entrances11310952entrances
entraps9109762entra_ps
entreats839772entreats
entrusts847112entrusts
errants7410642e_rrants
extracts1747622extracts
extranets1646362extranets
intranets949262intranets
intrant7318752intrant_
penetrants1245272penetrants
reentrants1044662reentrants
titrants838482titrants
alterants979103alterants
anurans73810553anuran_s
attracts1047793attracts
brants85723053__brants
centrals102712033centra_ls
centrings12227603centrings
centrists11410233centrists
contracts132212013contracts
contrasts112211043contrasts
courants10310803courants
currants1037933currants
denaturants1252413denaturants
detracts11138833detracts
dextrans1695983dextran_s
eluants737583e_luants
emigrants1244733emigrants
enacts84012973en__acts
enchant12313123enchant_
encrusts1045283encrusts
encrypts1542983encrypts
endrins8312163endrin_s
enframes1357453enframes
engraft11118623engraft_
engrails945383engrails
engrains937583engrains
engrams1038073engra_ms
engraves1237233engraves
enplanes1039483enplanes
enrages83114853en_rages
enrapt8313013en_rapt_
enroots738713en_roots
entails7912823ent_ails
entases72816273ent_ases
entasis73012573ent_asis
entente7412953ent_ente
ententes8312773ent_entes
enterons8314153enteron_s
enthralls12256133enthralls
enthrals11278903enthra_ls
enthrones12910073enthrones
entrain7313073entra_in
entrained1089413entrained
entrainer968583entrainer
entrainers1086963entrainers
entranced1247393entranced
entrap8710563entra__p
entrapments1546293entrapments
entreat7315263entreat_
entreaty1146173entreaty
entrees71813773entr_ees
entremets1147143entremets
entrench13115723entrench
entrepots1144253entrepots
entries71523163entr_ies
entrust7410883entrust_
entwines1148753entwines
entwists1156143entwists
enwraps1284833enwra_ps
errands847603e_rrands
errant6618733e_rrant_
estrange9488893estrange
estranges10359983estranges
estrays10529403estra_ys
estreats839423estreats
estrins7315853estrin_s
estrones8313323estrones
etchants1346023etchants
ethanes103713513e_thanes
explants1737023explants
extant132714753ext_ant_
extents142610173ext_ents
extract16311013extract_
extrados1645343extrados
extranet15412993extranet
extras13310223extra__s
gentians937563gentian_s
grants73722473__grants
hydrants1585793hydrants
incants92012803in_cants
indrafts1295583indrafts
infants102210773in_fants
infracts1346623infracts
ingrafts12105803ingrafts
instants8910153instants
insurants947653insurants
integrants1146693integrants
intents72115703int_ents
interacts11312123interacts
intrados946563intrados
intranet8418443intranet
intreats8311543intreats
intrigants1145053intrigants
introits859713introits
introns73515023intron_s
intrusts837723intrusts
jurants14379213_jurants
migrants1138183migrants
mutants938583mut_ants
octants9128733oct_ants
odorants946043odorants
operants1039483operants
outranks12298823outranks
penchants1646203penchants
pendants1139093pen_dants
penetrant1148463penetrant_
pennants1037063pen_nants
pentanes10316083pent_anes
rants55935343___rants
reentrant947843reentrant_
regrants9310013regrants
restraints1056603restraints
retirants947323retirants
retracts101111313retracts
saturants946383saturants
sentients948463sentients
sextants15287383sext_ants
sonorants947083sonorants
spirants1088283spirants
straits74916323_straits
strands83711953_strands
strunts7429543_strunts
tenants7311013ten__ants
titrant7315193titrant_
tracts85019073__tracts
traits65121983__traits
tranks104017763__tranks
tranqs155210313__tranqs
trans54933043__tran_s
truants738163__truants
tyrants1037453_tyrants
untracks1437523untracks
vagrants1246143vagrants
ventrals112910003ventra_ls
vibrants1345913vibrants
warrants1168503warrants

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.423422437.4
2DLD Change Limit1461621557.96618348.2
3Display Results1551550.0632460.3
 (SQL Overall)1786911558.45221141.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.