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 “keirs” 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
keirs9531368(None) 
heirs85618561heirs
kefirs13396651kefirs
keir86217881keir_
kiers95320101kiers
kirs85831751k_irs
weirs84316491weirs
airs46447432_airs
amirs75924922amirs
bears75739042bears
beers75628392beers
biers76225222biers
ceils75019402ceils
coirs75221052coirs
deairs74013782deairs
dears65736882dears
deers64930522deers
deils65722862deils
ears46356592_ears
emirs76116162emirs
errs45622532_errs
ers36046282_e_rs
fairs85825442fairs
fears84829392fears
firs76637722_firs
flirs85518932flirs
gears64628692gears
hairs86225172hairs
hears86737372hears
heils85222192heils
heir77523802heir_
hers75844872he_rs
jeers124818132jeers
kafirs13306982kafirs
kaifs125715652kaifs
kails95525222kails
kains96125652kains
kbars114612602kbars
keas86337102ke_as
kebars124112492kebars
kecks105416572kecks
keefs125116282keefs
keeks84717252keeks
keels94622412keels
keens95721182keens
keeps116020282keeps
keets95123482keets
kefir12457912kefir_
kefs115922752ke_fs
kegs95824032ke_gs
kelims1278912kelims
kelps115116422kelps
kelts95222632kelts
kemps135012522kemps
kenos95220622kenos
kens85435252ke_ns
kepis115313362kepis
keps106027312ke_ps
kerb104322722ke_rb
kerbs115013672kerbs
kerf115827472ke_rf
kerfs125413572kerfs
kern85326222ke_rn
kerns94719562kerns
kerry124916092kerry
kevils13358332kevils
kexes166216822kexes
keys116322172ke_ys
khis117017992khi_s
kids96029652k_ids
kiefs126112212kiefs
kier86526822kier_
kifs116023522k_ifs
kins85747922k_ins
kips106430532k_ips
kir76535692k_ir_
kirk76221582k_irk
kirks84915272k_irks
kirn87123452k_irn
kirns95315462k_irns
kis78051492k_i_s
kiss85227412k_iss
kits86441782k_its
kliks8398832kliks
knars94416112knars
knits93914752knits
knurs94511152knurs
kois85129412koi_s
kors85933022k_ors
kris86423612kri_s
kyars124813962kyars
lairs55425872lairs
lears55938732lears
leers54828982leers
lehrs86111132lehrs
leis45739602lei_s
liers55130402liers
mairs76228302mairs
mirs66940582_mirs
nears55529422nears
neifs85613042neifs
noirs55615462noirs
pairs75325832pairs
pears75138612pears
peers75130272peers
peins76128062peins
peris75537072peris
piers75926332piers
rears54739652rears
reifs84819092reifs
reins56234562reins
reis45343232rei_s
sears54744912sears
seers55136382seers
seifs85019332seifs
seis45542392sei_s
sers45746652se_rs
sirs44338342_sirs
skeins103911902skeins
skiers104713702skiers
speirs85013232speirs
stirs55921622stirs
tears55436462tears
theirs94610352theirs
tiers55526522tiers
vairs85019132vairs
veers84521362veers
veils84918802veils
veins84620492veins
viers85621952viers
wairs86424062wairs
wears86030302wears
weir76019922weir_
weird95111282weird
weirds10478052weirds
whirs115218092whirs
years84527672years
zeins144715392zeins

Search took 7 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 Filter178691538001.186150666.9
2DLD Change Limit538001385.3909981.4
3Display Results1381380.0801725.0
 (SQL Overall)1786911386.65626846.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.