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

218 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
confiner1331119(None) 
confider1438121confider
confine12315581confine_
confined14310401confined
confiners1439951confiners
confines13315651confines
coffined1735992coffined
coiner84323782co__iner
combiner14259722combiner
comfier1439162comfi_er
conciser12310242conciser
condoner112913412condoner
confer114018682conf__er
confide13310202confide_
confided1537452confided
confiders1537482confiders
confides14310572confides
confirmer1665662confirmer
confiteor1443872confiteor
confuter1338512confuter
congener112412202congener
conifer123212642con_ifer
coniine9316802coniine_
coniines10415362coniines
conine84528552con_ine_
conines93827792con_ines
conjoiner1855932conjoiner
conner84423962con__ner
conniver1337492conniver
consider11310392consider
consigner1246632consigner
container11311072container
continuer1148712continuer
convener132913162convener
convincer1645832convincer
bonfire1287063bonfire_
bonfires1367383bonfires
bonier84321993bon_i_er
bonnier94711313bonni_er
candider1237343candider
canine83826703can_ine_
canines93724033can_ines
canner84625983can__ner
cannier94014163canni_er
centner946853cen_tner
coalier93416183coali_er
cobbier133410163cobbi_er
cocaine111315173cocaine_
cocaines121314443cocaines
cocinera1245553co_cinera
cockier154013623cocki_er
codeine103815033codeine_
codeines113114523codeines
codifier1447163codifier
codriver1435913codriver
coffer144112863co_f_fer
coffin14339813coffin__
coffing163811253coffin_g
coffins153110193coffin_s
cognizer2055863cognizer
coifing133213893coifin_g
coiler84421593co__iler
coined94523603co__ined
coiners93620753co__iners
coinfer12419393co__infer
cointer93616723co__inter
cojoined1856293cojoined
colinear1045913co_linear
collider113410423collider
collier93618153colli_er
collinear1144113collinear
combine133014723combine_
combined15269183combined
combiners15247943combiners
combines142814623combines
comfiness1646953comfiness
commoner142710633commoner
communer14349303communer
compiler1438373compiler
conceder1338743conceder
conceiver1657413conceiver
concenter13312213concenter
concise11314473concise_
condemner1445763condemner
condenser1287413condenser
condoler113412123condoler
condone102616293condone_
condoned122612023condoned
condoners122811513condoners
condones112817393condones
conducer13127373conducer
conferee13613733conferee
conferrer1447063conferrer
confers124120093conf__ers
confident1549383confident
configure1544463configure
confining1539993confining
confirm1437363confi_rm
confirmed1745563confirmed
confirmers1744963confirmers
confirms1536303confirms
confit113316403confi__t
confiteors1543813confiteors
confits122811423confi_ts
confiture1445953confiture
conformer1667463conformer
confounder1643493confounder
confrere1347563conf_rere
confronter1544363confronter
confuse1238853confuse_
confused1437033confused
confuses13310363confuses
confute1239263confute_
confuted1437683confuted
confuters1437793confuters
confutes1339843confutes
congeners122511133congeners
conger95024273con__ger
conies84338593con_i_es
conifers133611703con_ifers
conin76232723con_in__
coning94331823con_in_g
conins84327233con_in_s
conjoined1965463conjoined
conjoiners1955403conjoiners
conjurer17117683conjurer
conker124721553con__ker
conking143618453conkin_g
conned95119703con__ned
conners94023113con__ners
conning103718753connin_g
connive1238993connive_
connived1436433connived
connivers1436933connivers
connivery1744213connivery
connives1339723connives
conominee1348163conominee
conquer1838623con_quer
consenter11312493consenter
considers1238933considers
consigned1346323consigned
consignee1246563consignee
consigners1346413consigners
consignor1244113consignor
consoler102812613consoler
conspirer1355293conspirer
consumer1238503consumer
contained12310893contained
containers1249903containers
contemner1347183contemner
contender1239563contender
continent11415633continent
continua1047653continua
continue10311123continue
continued1248483continued
continuers1247943continuers
continues11310993continues
continuo1047353continuo
contriver1448343contriver
convene123314323convene_
convened143412223convened
conveners142911443conveners
convenes132916913convenes
convenor13307613convenor
conveyer16278143conveyer
convince1547363convince
convinced1745363convinced
convincers1745063convincers
convinces1647833convinces
convoker17226903convoker
copier103722893co_pi_er
corkier133114303corki_er
corner84625623co__rner
cornier93017093corni_er
coroner94218203co_roner
corvine122113643corvine_
cosier84423753co_si_er
cosigner1135953cosigner
cosine83823513co_sine_
cosines94122673co_sines
cottier93814173cotti_er
courier93617893couri_er
cowier113616163co_wi_er
cowinner1334753cowinner
cowriter13238883cowriter
cozener18328953co_zener
cozier173315143co_zi_er
cunner83915003cun__ner
cunninger1242763cunninger
definer114413773_definer
donniker1333923donniker
finer85431563___finer
goofier11339313goofi_er
ionizer162310123ion_izer
joiner134114133jo__iner
loriner7511893lo_riner
moniker1338673mon_iker
nonfinal1147703nonfinal
noninert8415023non_inert
nonjoiner1665333nonjoiner
nonlinear944823nonlinear
nonowner1145253nonowner
nonsigner1045363nonsigner
officer1534213_officer
online6315843_online_
pontine92419053pontine_
reconfine1448013reconfine_
reconfined1645683reconfined
reconfines1546653reconfines
refiner105316913_refiner
sonsier7711743sonsi_er
tonier65520713ton_i_er
tonner64819203ton__ner
tontine72316143tontine_
tontines82114733tontines
unconfined1644433unconfined
wonkier1437423wonki_er
wonner95114443won__ner

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 Filter1786911461620.436409841.7
2DLD Change Limit1461622187.19020328.5
3Display Results2182180.0762868.4
 (SQL Overall)1786912187.70223200.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.