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

121 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
pulsant931056(None) 
passant9813942passant
peasant9314922peasant
pissant91012502pissant
plant75437112p_l_ant
pliant83918822p_liant
puissant10105392puissant
pulsar8329362pulsa_r
pulsars9358912pulsars
pulsate9510232pulsate
pulsing103712862pulsing
pursuant1046562pursuant
alant55742293_al_ant
aslant6317753asl_ant
brisant9312683brisant
buoyant1246263buoyant
callant94121223callant
currant9314173currant
eluant6315093_eluant
exultant1545483exultant
fulgent1138903fulgent
gallant83517113gallant
gelant72821673gel_ant
gellant83214053gellant
jessant1438443jessant
jurant134216553ju_rant
leant56737783__leant
mutant8317693mu_tant
nutant6316383nu_tant
opulent938833opul_ent
outsang83411273outsang
outsat62920283outsa_t
paesan85114093paesan_
paesani9348683paesani
paesano9338793paesano
paesans93312693paesans
pageant10312783pageant
paisan84417073paisan_
paisana94010223paisana
paisano9429513paisano
paisans93614753paisans
pant66061263p___ant
peasants1038263peasants
peccant13311733peccant
pedant9319493p_edant
peltast9310513peltast
pendant10314853pendant
pennant9312493pennant
persalt9315413persalt
petulant1048793petul_ant
pheasant1347083pheasant
piquant1848003piquant
pissants1097363pissants
plaint85323203p_laint
plait75631573p_l_ait
plan65833943p_l_an_
plane74929143p_l_ane
planet84228353p_l_anet
plank115221143p_l_ank
plans75731273p_l_ans
plants84921803p_l_ants
plat66048873p_l_a_t
pleasant1048323pleasant
pleat74734473p_lea_t
present94022733present
ptisan8417973ptisan_
ptisans9317363ptisans
puisne856353puis_ne
pula65129373pul_a__
puling93621403pul_ing
pullet84026333pul_let
pulling103821073pulling
pullman1135403pullman_
pullmans1253933pullmans
pullout9310593pullout
pulpal10408453pulpa_l
pulping123612323pulping
pulpit10310933pul_pit
puls65437563puls___
pulsated1136853pulsated
pulsates1048813pulsates
pulsating1236343pulsating
pulsator1085693pulsator
pulse74219973puls__e
pulsed94013723puls_ed
pulsejet1744023pulsejet
pulser84215193puls_er
pulsers94213153pulsers
pulses83818663puls_es
pulsion938393pulsion
pulsions1037713pulsions
pulsojet1754363pulsojet
pulvini1235073pulvini
pungent10311233pungent
punt65747203pu___nt
purana8712933pu_rana
pursing103715553pursing
purslane1045783purslane
pursuit948273pursuit
quant143624813qu__ant
reliant7319243reliant
saltant7316773saltant
slant55238703_sl_ant
suldan72611043suldan_
suldans8299723suldans
sultan63012593sultan_
sultana7257803sultana
sultans72411833sultans
ulan46527393_ul_an_
ulans54921303_ul_ans
ulpan7310123_ulpan_
ululant747693_ululant
unsent63820963_unsent
upland938863upl_and
upleapt11116863upleapt
upsent83314063_upsent
valiant10314623valiant
versant10313833versant
volant9316323vol_ant
yulan8411493yul_an_
yulans958673yul_ans

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.406440125.6
2DLD Change Limit1340271216.28321331.7
3Display Results1211210.0462630.4
 (SQL Overall)1786911216.73526531.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.