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

193 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
kainite114954(None) 
kainit10414481kainit_
kainites1238791kainites
kainits1137761kainits
crinite9513632crinite
finite9316822_finite
gahnite1135972gahnite
kaolinite1344042kaolinite
kernite1159472kernite
kyanite14237312kyanite
mannite9312902mannite
pinite8321242_pinite
aconite9315473aconite
adnate72913483_adnate
agnate73314883_agnate
agnize16329563_agnize
albite8313313_albite
alunite7311633alunite
aminity12310513aminity
amniote936963_amniote
anile54634463_a_nile
anime75423203_a_nime
anise55129703_a_nise
ante46538903_a_n_te
aplite8316393_aplite
arenite71017713arenite
asinine7310723asinine
augite7312613_augite
auntie64317703_auntie
axite125218253_a_xite
bailie83818363baili_e
barite84224813ba_rite
bauxite1635573bauxite
binate8419773_binate
binit76431583_binit_
binits85716673_binits
bornite9311183bornite
braunite1047253braunite
calcite11413783calcite
canine83826703ca_nine
caninity1338063caninity
cannie83819363canni_e
carinate103320243carinate
carnie84421093carni_e
crinites10612763crinites
cyanite122710763cyanite
dacite91115883da_cite
daintier937403daintier
dainties9312403dainties
dainty105311473dain_ty
definite1239323definite
dunite7315013_dunite
dunnite857333dunnite
ebonite9310293ebonite
faint85837063fain_t_
fainted114211723fain_ted
fainter103611053fain_ter
faints94818783fain_ts
finites10315923_finites
finito9310303_finito
flinkite1543623flinkite
gahnites1235703gahnites
gaining94015663gaining
gainst74914693gainst_
galenite91210063galenite
granite82017083granite
gunite7414403_gunite
haint85436323hain_t_
haints94417583hain_ts
halite93624233ha_lite
haplite12310703haplite
heinie92512663heini_e
ichnite1245983ichnite
ignite71410583_ignite
incite83618733__incite
indite73520323__indite
infinite1149593infinite
invite93715033__invite
jadeite1546403jadeite
kain85334293kain___
kains96125643kain__s
kalifate1556493kalifate
kamacite1645293kamacite
kane85133973ka_n__e
kaoline11310143kaoline
kaolinites1443413kaolinites
kaonic1238763kaoni_c
karate105320923ka_rate
kente95821063k_en_te
kernites1269113kernites
keynote1443903keynote
khanate1437073khanate
kibitz2177643k_ibitz
kiltie103210963k_iltie
kinase104210653k_inase
kindle114414233k_indle
kine85643423k_in__e
kinin94917323k_ini_n
kinins104014583k_inins
kite85338233k___ite
knife1210010133k__nife
knit85728143k__nit_
knits93914743k__nits
koine9516483koin__e
kunzite2053503kunzite
kyanise14236143kyanise
kyanites15216683kyanites
kyanize23265343kyanize
laciniate1156843laciniate
laicise939333laicise
laicize1838093laicize
laminate103014633laminate
lanate6421263la_nate
latinity1138813latinity
latinize17610563latinize
lenite6719983_lenite
lignite81310303lignite
magnate10512703magnate
mainline1039863mainline
manito8518693ma_nito
manitu8315823ma_nitu
mannites10312613mannites
marinate103017783marinate
marlite92917073marlite
marmite112413993marmite
masonite1049683masonite
maximite1955853maximite
meinie82614523meini_e
melinite10411743melinite
minute83414293_minute
naivete1055663naivete
nannie63713223nanni_e
nite45943583___nite
paginate114012443paginate
paining103920243paining
paint75443693pain_t_
painted104214633pain_ted
painter93814563pain_ter
paintier1048793paintier
paints85921833pain_ts
painty114714753pain_ty
pantie84326473pa_ntie
partite9317133partite
patinate103016313patinate
patinize19610773patinize
pinites9319533_pinites
pointe84619313poin_te
quinate16511573quinate
quinine163011043quinine
quinte153414523quin_te
rainier71614263rainier
rainily10310433rainily
raining83922693raining
ratite65022423ra_tite
reignite947233reignite
reincite1089703reincite
reinvite1177753reinvite
retinite8314853retinite
reunite7312713reunite
ruinate7312833ruinate
saining83621393saining
saint55147073sain_t_
sainted84114243sain_ted
saints65122423sain_ts
salinity1138893salinity
salinize1739683salinize
samite83020603sa_mite
sanity9316203sa_nity
saponite10410533saponite
sienite7312713sienite
slainte738543slain_te
spinate93114813spinate
stannite847583stannite
stibnite1044073stibnite
syenite1039773syenite
taconite1049313taconite
taeniae739083taeniae
taint55542283tain_t_
tainted83512423tain_ted
taints64520533tain_ts
tannate71813523tannate
taxite13511303ta_xite
trinity10310843trinity
unite54828383__unite
uraninite946743uraninite
uranite72515693uranite
urinate7315363urinate
vaginate123911083vaginate
vanity12311933va_nity
vauntie1036633vauntie
vawntie1343943vawntie
zincite1837233_zincite
zoisite1635833zoisite

Search took 8 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.1561145455.1
2DLD Change Limit1340271936.78019768.0
3Display Results1931930.0633063.5
 (SQL Overall)1786911936.99925530.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.