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

178 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
iterant731778(None) 
alterant8614962alterant
inerrant8412492inerrant
integrant1049832integrant
interact10316472interact
intrant7318752intrant
iterance1049522iterance
iterate71119112iterate
itinerant945192itinerant
operant9317222operant
tenant6322472_tenant
titrant7315192titrant
tyrant9315332_tyrant
aberrant1049543aberrant
abeyant1248083abeyant
alterants979103alterants
alternant977133alternant
arrant6623253_arrant
attract9511833attract
bezant17814543_bezant
brant74742173__brant
cateran9313773cateran_
caterans10313223caterans
cauterant1148533cauterant
cotenant10511793cotenant
courant9317973courant
currant9314173currant
decant93524223_decant
derat65044083_dera_t
detract101414633detract
dipteran1146203dipteran_
dipterans1245723dipterans
elegant8311503elegant
entrant7318873entrant
errant6618733_errant
etchant1249823etchant
eternal72910893eternal
eterne6311723eter_ne
figurant1246723figurant
gelant72821673_gelant
gerent73223103_gerent
grant64840023__grant
hydrant1489053hydrant
iceman1037853iceman_
ignorant947153ignorant
ikebana1342693ikebana
implant11311333implant
imprint11312563imprint
incant82418513i_ncant
indraft1199573indraft
inebriant1146293inebriant
inert53234373iner__t
inexact1647413inexact
infant92315133i_nfant
infract12610003infract
ingraft1199503ingraft
inherent11412793inherent
instant7815353instant
insurant8411433insurant
integrand1145033integrand
integrants1146693integrants
intendant1047713intendant
intent63122773inte__nt
interacts11312123interacts
interage9314493interage
interbank1547043interbank
intercut10411113intercut
interest8319183interest
intergang11117893intergang
interknit1358333interknit
interknot1356903interknot
interlent9416733interlent
intermat101114613intermat
interment11419223interment
intermit101213593intermit
intermont11513573intermont
intern64016543inter_n_
internal8414083internal
interne73218153inter_ne
interns73116773inter_ns
interplant12119573interplant
interunit959833interunit
intolerant1056143intolerant
intranet8418443intranet
intrants8312863intrants
intreat7416303intrea_t
issuant748263issuant
iteming1037753iteming
iterances1148913iterances
iterated91213823iterated
iterates81317823iterates
iterating10314253iterating
iterum837903iter_um
itinerants1052983itinerants
jurant134216553_jurant
leant56737783_le_ant
learnt64019253_learnt
levant9314493_levant
libelant1048563libelant
literacy1346803literacy
literal7613273litera_l
literals8312293literals
literary1147753literary
literate81216893literate
literati81210803literati
litigant946873litigant
meant76537213_me_ant
migrant10314313migrant
mitering113015403mitering
odorant8411393odorant
operand1038003operand
operants1039483operants
overact12315043overact
overapt12312653overapt
pedant9319493_pedant
pterin81014153pterin_
pterins9812993pterins
rant45864683___rant
recant83228683_recant
regrant8317323regrant
reran57329103_reran_
rerent63832453_rerent
retirant8313593retirant
retract91318113retract
saturant8410643saturant
secant84023293_secant
sejant133114483_sejant
servant10313633_servant
setenant849933setenant
spirant9814293spirant
statant7313123statant
stent55634513ste__nt
sterilant947283sterilant
sterlet71318473sterlet
stern55319123ster_n_
sterna63712763ster_na
sternal73411913sternal
sterns64616763ster_ns
strait64025893st_rait
strand74514823st_rand
strang75718313st_rang
strunt64918913st_runt
teat45963633_te_a_t
tenants7311013_tenants
tent46159863_te__nt
terai53525483_tera_i
terais64023513_terais
teraph11319093_teraph
tercet83624913_tercet
tern46134803_ter_n_
ternate7415483_ternate
terne56426153_ter_ne
terns55226873_ter_ns
terrane72814233_terrane
terret63425623_terret
territ63421373_territ
tetany959843_tetany
tiering8315253tiering
titrants838483titrants
titubant1044613titubant
tolerant8411463tolerant
tract75635713_t_ract
trait56940843_t_rait
trank96222423_t_rank
tranq145416893_t_ranq
trans54933043_t_rans
trapt76433393_t_rapt
treat56240353_trea_t
truant6315783_truant
tyrants1037453_tyrants
uterine7315193uterine
vagrant11410663vagrant
verdant11313293_verdant
versant10313833_versant
veteran1039353veteran_
veterans1148853veterans
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.406440125.6
2DLD Change Limit1340271786.29621287.6
3Display Results1781780.0632825.4
 (SQL Overall)1786911786.76526414.0
 
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.