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

207 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
intrant731875(None) 
entrant7318871entrant
intranet8418441intranet
intrants8312861intrants
entrants8311752entrants
ignorant947152ignorant
incant82418512in_cant
indraft1199572indraft
inerrant8412492inerrant
infant92315132in_fant
infract12610002infract
ingraft1199502ingraft
instant7815352instant
insurant8411432insurant
intact8314662int_act
integrant1049832integrant
intent63122772int_ent
interact10316472interact
intranets949262intranets
intreat7416302intreat
intrigant1047682intrigant
introit7414532introit
intron64215022intron_
introns73515022introns
intrust7311492intrust
iterant7317782iterant
titrant7315192titrant
alterant8614963alterant
antra56521923antra__
antral65719413antra_l
anuran64313243anuran_
anurans73810553anurans
arrant6623253_arrant
attract9511833attract
brant74742173__brant
contract122915633contract
contrast102614783contrast
courant9317973courant
currant9314173currant
detract101414633detract
distant83519953dist_ant
distract11313023distract
distraint101112903distraint
distrait9414343distrait
enchant12313123enchant
engraft11118623engraft
enrapt8313013en_rapt
entrain7313073entrain
entrains8312963entrains
entrance10311333entrance
entrap8710563entra_p
entraps9109763entraps
entreat7315263entreat
entrust7410883entrust
errant6618733_errant
extant132714753ext_ant
extract16311013extract
extranet15412993extranet
figurant1246723figurant
grant64840023__grant
hydrant1489053hydrant
implant11311333implant
imprint11312563imprint
inane52820343in__ane
inapt73522693in__apt
incants92012803in_cants
incent83320723in_cent
incitant10810083incitant
incrust949203incrust
indent73021243in_dent
indicant11410343indicant
indrafts1295583indrafts
indrawn1145093indrawn
inebriant1146293inebriant
inert53234373iner__t
inexact1647413inexact
infanta10237253in_fanta
infante101910883in_fante
infants102210773in_fants
infarct1249013infarct
informant1446473informant
infra838643infra__
infracts1346623infracts
ingrafts12105803ingrafts
ingrain839523ingrain
ingrains948983ingrains
ingrate8715123ingrate
inhalant1147403inhalant
inherent11412793inherent
inland7310313in_land
inrun52911373in_run_
inruns6359513in_runs
insane6314893in_sane
inspan837513inspan_
inspans937803inspans
instants8910153instants
instruct1047543instruct
insulant849883insulant
insurants947653insurants
intake10510863int_ake
integrand1145033integrand
integrants1146693integrants
intend72310373int_end
intendant1047713intendant
intents72115703int_ents
interacts11312123interacts
interage9314493interage
interbank1547043interbank
intercut10411113intercut
interest8319183interest
intergang11117893intergang
interknit1358333interknit
interknot1356903interknot
interlent9416733interlent
intermat101114613intermat
interment11419223interment
intermit101213593intermit
intermont11513573intermont
intern64016543intern_
internal8414083internal
interne73218153interne
interns73116773interns
interplant12119573interplant
interunit959833interunit
inthral10249463inthra_l
inthrall11247063inthrall
inthrals11258503inthrals
inthrone1179473inthrone
intine61021983int_ine
intolerant1056143intolerant
intonate8310923intonate
intone61115433int_one
intort6418923int_ort
intown936153intown_
intracity1448423intracity
intraday1244803intraday
intrados946563intrados
intreats8311543intreats
intrench1396593intrench
intrigants1145053intrigants
intriguant1154253intriguant
intro54915853intr__o
introfy1344753introfy
introits859713introits
intromit1048743intromit
intros64215773intr_os
intrude837403intrude
intrusts837723intrusts
intuit6314083int_uit
inturn63411563inturn_
inturns73210133inturns
intwine1038513intwine
intwist1038043intwist
inundant945783inundant
inurbane1045253inurbane
inuring81213013inuring
inurn53712863inur_n_
inurns63310983inur_ns
invariant1266813invariant
invent93316363in_vent
inwrap11115903inwra_p
inwraps12105253inwraps
issuant748263issuant
itinerant945193itinerant
jurant134216553_jurant
migrant10314313migrant
ministrant1255813ministrant
mutant8317693mut_ant
natant6318733_natant
nitrate72017013nitrate
nutant6316383_nutant
octant81216553oct_ant
odorant8411393odorant
ointment1069233ointment
operant9317223operant
outran63218893outran_
outrang83813953outrang
outrank112611973outrank
penetrant1148463penetrant
pintano998993pint_ano
rant45864683___rant
reentrant947843reentrant
regrant8317323regrant
retirant8313593retirant
retract91318113retract
saturant8410643saturant
sonorant8411703sonorant
spirant9814293spirant
strait64025893_strait
strand74514823_strand
strang75718313_strang
strunt64918913_strunt
titrants838483titrants
tract75635713__tract
trait56940843__trait
trank96222423__trank
tranq145416893__tranq
trans54933043__trans
trapt76433393__trapt
truant6315783__truant
tyrant9315333_tyrant
unmeant9510903unmeant
unrent63219783un_rent
untrack1338703untrack
vagrant11410663vagrant
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.470380193.6
2DLD Change Limit1340272076.09321996.9
3Display Results2072070.0932225.8
 (SQL Overall)1786912076.65626846.6
 
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.