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

180 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
cinerin931382(None) 
cinerins10414101cinerins
cindering13311222cindering
citrin82615412ci_trin
dineric10310972dineric
kinetin11248262kinetin
ninepin945572ninepin
aileron739833aileron
aneurin749833_aneurin
biner75930693biner__
biners85023633biner_s
canakin131810833canakin
caner75334773caner__
caners84629203caner_s
canikin13189753canikin
cankering162110793cankering
cantering122417373cantering
cantrip112910043cantrip
capelin11510973capelin
capering132414963capering
casein83216453case_in
casern84713313caser_n
cateran9313773cateran
catering112019903catering
cavern115312453caver_n
centering122915143centering
centric11312403centric
centring112112953centring
ceria75125353c__eria
ceric94023093c__eric
cering94522533c__ering
chagrin1337893chagrin
cheering143612703cheering
cheerio12379313cheerio
chimeric1746743chimeric
chlorin123113003chlorin
ciboria1147043ciboria
cicero1048503cicer_o
cicerone1247523cicerone
ciceroni1244853ciceroni
ciceros1158583ciceros
cider84723313cider__
ciders94620093cider_s
cinching163310223cinching
cinder94119123cinder__
cindered1239793cindered
cinders104617763cinder_s
cindery13429193cinder_y
cine66242943cine___
cineast9310523cineast
cinema1047653cine_ma
cinemas1138043cinemas
cineol8108203cine_ol
cineole91010003cineole
cineols9128853cineols
cineraria1145113cineraria
cinerary1346433cinerary
cines75239683cine__s
cinquain1943513cinquain
ciphering17217703ciphering
cipolin1148783cipolin
cirri7710723ci_rri_
cistern93310703cister_n
cistron9299883cistron
citer74827333citer__
citers85022983citer_s
cithern12489913cither_n
cithren12306593cithren
citric102812313ci_tric
citrine92514023ci_trine
citrins92614363ci_trins
citron83112983ci_tron
cittern9339143citter_n
cleric10612133c_leric
clerid9312413c_lerid
clinkering1745233clinkering
codein94916723code_in
cohering142413833cohering
coiner84323783coiner__
coiners93620753coiner_s
coinhering1647313coinhering
concern113011963concer_n
conin76232723con__in
conjoin1638203conjoin
contain9315833contain
cornering12311893cornering
coterie9417403coterie
covering142215723covering
cowering142514033cowering
cretin82917913c_retin
criteria1047993criteria
criterion1145293criterion
culverin1345173culverin
cumarin1139263cumarin
dimeric12310013dimeric
diner65632903diner__
dinero75612643diner_o
dineros83812333dineros
diners75525953diner_s
dynein1035563dyne_in
endrin7312403_endrin
fibrin1138533fi_brin
finer85431563finer__
fineries112416743fineries
finery124512893finer_y
fingering1439193fingering
finikin14266863finikin
generic101310753generic
gingering1238873gingering
hindering14310273hindering
icteric1138023icteric
indri6310793_indri_
indris7311963_indris
inert53234373_iner_t
inertia7410203_inertia
inerts64517023_inerts
ingrain839523_ingrain
inhering12913713_inhering
inherit10312973_inherit
inrun52911373_in_run
interim9912873_interim
intern64016543_inter_n
intron64215023_intron
inulin6311733_inulin
inuring81213013_inuring
inurn53712863_inur_n
invertin11910233_invertin
kaiserin1245023kaiserin
kinesic13257023kinesic
kinesis11259593kinesis
kinetic13209173kinetic
kinetins12228153kinetins
kingpin1445003kingpin
kinin94917323kin__in
lineman939123lineman
linemen938633linemen
linen55728723line__n
liner55938923liner__
liners65428853liner_s
lingerie959203lingerie
lingering11310513lingering
linin58025523lin__in
linuron746513linuron
livering122012383livering
luciferin14152463luciferin
miner76933543miner__
mineral9312733mineral
miners84126633miner_s
minikin13258983minikin
minoring11311473minoring
mirin75023153mi__rin
mitering113015403mitering
moneran9311113moneran
nidering10510483nidering
ninepins1045873ninepins
niterie7313743niterie
pineries102419083pineries
pinery115214293piner_y
pinyin112710613pin_yin
piperine122011833piperine
pterin81014153_pterin
riverine11310803riverine
serin55434443__serin
sinewing1267593sinewing
sintering101014803sintering
suberin9314563suberin
tiderip1045513tiderip
tiepin839343ti_epin
tiering8315253ti_ering
tineid74412023tine_id
tinkering1437703tinkering
vigneron1243013vigneron
vineries112716043vineries
vinery124912603viner_y
viperine13189713viperine
wineries112316533wineries
winery125014283winer_y
wineskin1544243wineskin
wintering13412363wintering
wivern12409283wiver_n

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.406440125.6
2DLD Change Limit1340271806.70319995.1
3Display Results1801800.0762368.4
 (SQL Overall)1786911807.18524870.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.