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

168 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
immune103542(None) 
immane1038871immane
immunes1136081immunes
immure1036021immure
ammine10314482ammine
commune13329352commune
imbue939462imbu_e
imine75821042i_mine
immense1135292immense
immunise1245332immunise
immunize2144652immunize
immured1235062immured
immures1136712immures
impone103011852impone
impure1038372impure
impute1038032impute
almuce10348213almuce
almude9399933almude
amine75835373_amine
ammines11312673ammines
ammino1069873ammino
ammono1047373ammono
amount8414483amount
ampule10710613ampule
amuse75920833_amuse
armure8710133armure
attune637983attune
bemuse1038943bemuse
cohune1189423cohune
communed15338203communed
communer14349293communer
communes143411233communes
commute134310423commute
cymene1377393cymene
demure9311533demure
diamine10311973diamine
dimming13339583dimming
domine92918253domine
dune56137583__dune
emeute838533emeute
ermine8416923ermine
famine114318193famine
gamine94620153gamine
gemmule12173233gemmule
gimme102411343gimm__e
gimmie11298173gimm_ie
humane112812173humane
illude7327503illude
illume8298223illume
image81411283i_mage
imagine1037873imagine
imamate1138093imamate
imaum9139633imau_m
imaums10106293imaums
imbibe1234683imbibe
imbrue1035133imbrue
imbrute1144903imbrute
imbued1136153imbued
imbues1037963imbues
imbuing1236083imbuing
imide85716873i_mide
imines84918343i_mines
imino74315213i_mino
immanent1246803immanent
immature1244433immature
immenser1244173immenser
immerge1244703immerge
immerse1145793immerse
immesh1334103immesh
immies102412423immies
imminent1247513imminent
immingle13124323immingle
immix1635013imm_ix
immixed1933563immixed
immixes1835063immixes
immunised1453903immunised
immunises1344943immunises
immunity1544723immunity
immunized2353963immunized
immunizer2243263immunizer
immunizes2244583immunizes
immunogen1463033immunogen
immuring1335533immuring
immy114611823imm__y
impale102811653impale
impanel1137093impanel
impede11469613impede
impend11478783impend
imphee13310343imphee
imping114315333imping
impinge12427493impinge
imponed12279453imponed
impones112712253impones
impose103113043impose
impound1235393impound
impugn1143153impugn
impugned14333923impugned
impugner13444233impugner
impugns1243333impugns
impulse1135113impulse
impurer1136483impurer
imputed1236533imputed
imputer1136533imputer
imputes1138083imputes
inane52820343i_nane
incuse83513573incuse
indene73215373indene
induce93811533induce
indue63516673indu_e
infuse93110573infuse
inhume1196583inhume
injure133410863injure
inmate82917353inmate
inrun52911373inrun_
inruns6359513inruns
insane6314883insane
insure63416603insure
intine61021973intine
intone61115423intone
inure54119053i_nure
iodine74618643iodine
ionone6313443ionone
irone55126363i_rone
issue559213issu_e
jejune1233763jejune
jimmie17376463jimm_ie
jimminy2133363jimminy
kune85424573__kune
lacune8169673lacune
lagune7158633lagune
lune47140493__lune
mane65052013__mane
maun65727203_maun_
maund85515443_maund
mauve104013273_mauve
mesne75116293_mesne
mime85736393mim__e
miming114317253miming
mine67256153__mine
minute83414293minute
mistune9310653mistune
misuse83213643misuse
mizuna1734303mizuna
moue65835573_mou_e
mound83918313_mound
mount74128063_mount
mouse77133003_mouse
mule65236973__mule
mun56143853__mun_
muni65824403__muni
muns65535913__muns
mure65941333__mure
muse67136033__muse
mute65136873__mute
nimming12358133nimming
nonimmune1352023nonimmune
osmund933803osmund
premune1138933premune
prune75119633_prune
retune69121953retune
rimming123411063rimming
rune45236293__rune
triune64210183triune
tune45635863__tune
untune62511603untune
wimmin1336143wimmin_
yamun10419273yamun_
yamuns11336513yamuns

Search took 6 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 Filter1786911127160.1231452772.4
2DLD Change Limit1127161684.86023192.6
3Display Results1681680.0632666.7
 (SQL Overall)1786911685.04635412.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.