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

138 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
confer11401868(None) 
coffer144112861coffer
coinfer12419391coinfer
confers124120091confers
conger95024271conger
conifer123212641conifer
conker124721551conker
conner84423961conner
bonder95324782bonder
boner75133082bon_er
bonier84321992bonier
bonzer175313672bonzer
cancer104220922cancer
caner75334772can_er
canker124422522canker
canner84625982canner
canoer85121072canoer
canter85230112canter
censer84516582censer
center84421412center
chafer144714572chafer
cinder94119122cinder
cloner84418092clon_er
coaler84121712coaler
coater84329572coater
coaxer153912792coaxer
cobber124116842cobber
cocker144320392cocker
codder104416342codder
coder86134222co_der
codger105814872codger
coffee144113742coffee
coffers154112692coffers
coifed124113062coifed
coiler84421592coiler
coiner84323782coiner
coinfers13349502coinfers
cointer93616722cointer
colder95121852colder
colter84625092colter
comber125118502comber
comer95832692co_mer
comfier1439162comfier
concern113011962concern
concert113325222concert
concur10411102concur
condor94616972condor
cone67256962con_e_
coned86040052con_ed
cones76457422con_es
coney105932882con_ey
confab1347062confab
confect143614272confect
conferee13613732conferee
conferva1644432conferva
confess12399902confess
confider1438122confider
confiner13311192confiner
confirm1437362confirm
confit113316402confit
conform14310462conform
confrere1347562confrere
confuter1338512confuter
conge85227592conge_
congee96024472congee
congers104223232congers
conges94928172conges
conies84338592conies
conifers133611702conifers
conked135019112conked
conkers133721042conkers
conned95119702conned
conners94023112conners
conquer1838622conquer
conte76633202conte_
contes84432912contes
convert123721472convert
convex18367742convex
convey144610222convey
cooer74831012co_oer
cooker124722452cooker
cooler84824712cooler
cooper104221122cooper
cooter85128612cooter
coper95336092co_per
copier103722892copier
copper124321892copper
copter109822012copter
corder94322882corder
corer75538872co_rer
corker124720852corker
corner84625622corner
cornfed1337382cornfed
cornier93017092cornier
cosher114819902cosher
cosier84423752cosier
coster84331292coster
cotter84926672cotter
counter94220152counter
couter84930222couter
cover105430772co_ver
cower104531772co_wer
cowier113616162cowier
coyer105222842co_yer
cozier173315142cozier
cunner83915002cunner
doffer133911352doffer
fonder104120062fonder
gofer94814282go_fer
goffer13409512goffer
golfer104411182golfer
goner66025162gon_er
honer85332092hon_er
honker134117462honker
hoofer124014952hoofer
infer84215032_infer
loafer93610942loafer
loner55431042lon_er
longer75823202longer
monger94418332monger
offer114311382_offer
ponder94521692ponder
reconfer1337672reconfer
rolfer94412272rolfer
roofer94415282roofer
scoffer15317022scoffer
sonder73623522sonder
toner55336242ton_er
tonger74719682tonger
tonier65520712tonier
tonner64819202tonner
wolfer12429982wolfer
wonder103617812wonder
wonner95114442wonner
woofer124411362woofer
yonder103214132yonder
yonker134110852yonker
zoner144520342zon_er

Search took 3 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.343520965.0
2DLD Change Limit825511382.47033421.5
3Display Results1381380.0463000.0
 (SQL Overall)1786911382.85962501.2
 
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.