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

104 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
bairn7751553(None) 
airn46433831_airn
bairns86710871bairns
barn66444641ba_rn
cairn75717511cairn
ain37579092_ai_n
air38058392_air_
airns55521032_airns
airs46447422_airs
airt45757782_airt
airy75734152_airy
bacon95620592bacon
bail65042802bai_l
bails75933522bails
bairnly1234502bairnly
bait66556002bai_t
baith108023132baith
baits76630582baits
baiza164813222baiza
baize164717392baize
ban58366842ba__n
banian8315382banian
bar58070552ba_r_
barb85240062ba_rb
bard75648862ba_rd
bare65460522ba_re
barf95844412ba_rf
baric96125692baric
baring95135852baring
bark106242152ba_rk
barm86739602ba_rm
barns76335142ba_rns
barny105821732ba_rny
baron78131242baron
barre75929542barre
barren85317612barren
bars66564092ba_rs
basin75026922basin
basion84315852basion
baton75822422baton
bin56658642b_i_n
bird76128322b_ird
birk106326862b_irk
birl65830472b_irl
biro66131212b_iro
birr66022362b_irr
blain75421792blai_n
blin67228172bli_n
born67338412b_orn
bourn75518482bourn
brain76229382brai_n
brin67038192bri_n
burin75626062burin
burn65636432b_urn
cain65643912cai_n
caird85717232caird
cairns85313302cairns
cairny11557822cairny
carn66245432ca_rn
dairy97016302dairy
darn56434622da_rn
earn46737552ea_rn
fain75840562fai_n
fair76332522fair_
fairs85825442fairs
fairy115318282fairy
firn76927502_firn
gain56042162gai_n
girn56026862_girn
hair76330142hair_
hairs86225172hairs
hairy115316832hairy
kain85334292kai_n
karn86129412ka_rn
kirn87123442_kirn
lain46146282lai_n
lair45934152lair_
laird65417792laird
lairs55425872lairs
main65345522mai_n
mair66133782mair_
mairs76228302mairs
naira5314742naira
nairu5413812nairu
pain65647242pai_n
pair66031512pair_
pairs75325832pairs
pirn67128372_pirn
rain46251732rai_n
sain45551292sai_n
sarin55239252sarin
shairn9269062shairn
tain45548072tai_n
tarn46842722ta_rn
vain75233002vai_n
vair75624142vair_
vairs85019132vairs
wain75840202wai_n
wair75830052wair_
wairs86424062wairs
warn75239322wa_rn
yaird96111912yaird
yarn75230042ya_rn
zaire14311992zaire

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 Filter178691538000.313570897.8
2DLD Change Limit538001041.71631352.0
3Display Results1041040.0333151.5
 (SQL Overall)1786911042.06286659.1
 
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.