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 “coiner” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

166 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
coiner8432378(None) 
coiler84421591coiler
coined94523601coined
coiners93620751coiners
coinfer12419391coinfer
cointer93616721cointer
conner84423961conner
corner84625621corner
joiner134114131joiner
aliner65621982aliner
biner75930692_biner
boiler84319272boiler
boner75133082bo_ner
bonier84321992bonier
briner84519042briner
caner75334772c_aner
canner84625982canner
ceiler84013962ceiler
chicer134513602chicer
chider125116052chider
chimer135517202chimer
chine105231722chine_
chined125620062chined
chines115029172chines
choicer14197892choicer
cider84723312c_ider
cinder94119122c_inder
cine66242942c_ine_
cines75239682c_ines
citer74827322c_iter
cline76428532cline_
clines84926042clines
clinger103812142clinger
clinker133811662clinker
cloner84418092cloner
coaler84121702coaler
coater84329552coater
coaxer153912782coaxer
cobber124116842cobber
cocinera1245552cocinera
cocker144320392cocker
codder104416332codder
coder86134212co_der
codger105814842codger
coffer144112862coffer
coifed124113062coifed
coigne94612192coigne_
coigned11418662coigned
coignes103912152coignes
coiled95123932coiled
coilers93619902coilers
coin66645352coin__
coinfers13349502coinfers
coinhere1337132coinhere
coins75834552coin_s
cointers103616402cointers
coir66327242coi__r
colder95121832colder
colinear1045912colinear
colter84625092colter
comber125118502comber
combiner14259722combiner
comer95832692co_mer
cone67256962co_ne_
coned86040052co_ned
cones76457422co_nes
coney105932882co_ney
confer114018682confer
confiner13311192confiner
conger95024272conger
conies84338592conies
conifer123212642conifer
conine84528552conine_
conines93827792conines
conker124721552conker
conned95119702conned
conners94023112conners
cooer74831012co_oer
cooker124722452cooker
cooler84824712cooler
cooper104221122cooper
cooter85128612cooter
coper95336092co_per
copier103722892copier
copper124321892copper
copter109822012copter
corder94322872corder
corer75538872co_rer
corker124720852corker
cornea84018922cornea
corned95224522corned
cornel84020052cornel
corners94723312corners
cornet84436732cornet
cornier93017082cornier
coroner94218202coroner
cosher114819902cosher
cosier84423752cosier
cosigner1135952cosigner
cosine83823512cosine_
cosines94122672cosines
coster84331292coster
cotter84926672cotter
counter94220142counter
couter84930202couter
cover105430772co_ver
cower104531772co_wer
cowier113616162cowier
cowinner1334752cowinner
coyer105222842co_yer
cozener18328952cozener
cozier173315142cozier
crier74724462cri_er
cringer103514242cringer
crooner93714042crooner
crowner124012592crowner
cunner83915002cunner
diner65632902_diner
downer104414922downer
eloiner7149182eloiner
fainer94717242fainer
finer85431562_finer
foined105915012foined
gainer74117492gainer
goiter74116202goiter
goner66025152go_ner
honer85332092ho_ner
joinder15337592joinder
joined144613072joined
joiners144211572joiners
joinery17366592joinery
jointer14379712jointer
koine9516482koine_
koines10415732koines
liner55938912_liner
loaner64416502loaner
loiter64619172loiter
loner55431032lo_ner
loriner7511882loriner
miner76933542_miner
moaner84415112moaner
moiler84017262moiler
mooner85317832mooner
oiler54628282_oiler
owner84613312_owner
pointer93814932pointer
poiser84217242poiser
ruiner64013642ruiner
scorner9259762scorner
seiner64622482seiner
shiner93820872shiner
sooner64220462sooner
sorner64720382sorner
toiler63918282toiler
toner55336242to_ner
tonier65520712tonier
tonner64819202tonner
twiner94012592twiner
vainer93714572vainer
veiner94514752veiner
voicer113910542voicer
voider103611552voider
weiner94214132weiner
whiner124516632whiner
wonner95114442wonner
zoner144520342zo_ner

Search took 4 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 Filter178691825510.1261418182.5
2DLD Change Limit825511663.15626156.8
3Display Results1661660.1101509.1
 (SQL Overall)1786911663.39252680.1
 
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.