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

197 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
khis11701798(None) 
ahis76135381ahis
chis95933311chis
ghis85020161ghis
his66359501_his
khi106318301khi_
kis78051481k_is
kois85129401kois
kris86423601kris
phis95724901phis
this76027381this
ahi68040232ahi_
ahs68644822ah_s
ais39083572_ais
amis66445322amis
anis45746462anis
aphis105917132aphis
axis116127912axis
bis56860662_bis
bris65539612bris
chais107530312chais
chi86228652chi_
chia96026622chia
chias104625522chias
chic115925202chic
chics123920942chics
chid106626402chid
chin96934742chin
chins105631462chins
chip116726422chip
chips125721252chips
chit96937462chit
chits105424572chits
cis57748032_cis
cris66233432cris
dais57040702dais
dis46459892_dis
egis56520652egis
ghi77019882ghi_
has67372652_has
hes66654202_hes
hi57947582_hi_
hic86540562_hic
hid76248382_hid
hie67652702_hie
hies74842832_hies
him86247662_him
hims95230972_hims
hin67559562_hin
hins76447992_hins
hip86750432_hip
hips96433702_hips
hisn79620932_hisn
hiss75629212_hiss
hist76551542_hist
hit66569192_hit
hits75545132_hits
hos68364192_hos
ibis66519582ibis
iris45732552iris
is27048212__is
iwis77117012iwis
kaas86531842kaas
kabs107130842kabs
kadis105921062kadis
kaes85734062kaes
kafs116423742kafs
kaif116933932kaif
kaifs125715642kaifs
kail85131492kail
kails95525212kails
kain85334292kain
kains96125642kains
kakis86116842kakis
kas77058582k_as
kats85944332kats
kays116032192kays
keas86337092keas
kefs115922742kefs
kegs95824022kegs
keir86217872keir
keirs95313672keirs
kens85435232kens
kepis115313362kepis
keps106027302keps
keys116322162keys
khadis1446912khadis
khaf145319602khaf
khafs15648842khafs
khakis1265852khakis
khan115819142khan
khans124615172khans
khat116730722khat
khats125316012khats
khet116328622khet
khets124913432khets
ki67537962k_i_
kid86540622k_id
kids96029642kids
kif105941192k_if
kifs116023512kifs
kin76353972k_in
kins85747912kins
kip97042142k_ip
kips106430522kips
kir76535682k_ir
kirs85831742kirs
kiss85227402kiss
kist86540802k_ist
kit78559882k_it
kits86441772kits
kiwis12328582kiwis
klik74412652klik
kliks8398822kliks
knish1238602knish
knit85728142knit
knits93914742knits
koas85635092koas
kobs105831082kobs
kohls12437802kohls
koi77534752koi_
kojis16468442kojis
kops107031292kops
kors85933012kors
kos76944822k_os
koss85224812koss
kues86426772kues
kufis1249252kufis
kvas117015942kvas
kyes115124932kyes
leis45739602leis
lis37162272_lis
mhos95517772mhos
mis58162622_mis
obis66226842obis
ohia75719362ohia
ohias84415572ohias
ohms95514032ohms
ohs66232312oh_s
phi86524202phi_
phiz186718842phiz
pis56362032_pis
pois66539042pois
psis68120342psis
qis126934382_qis
rais45252622rais
reis45343232reis
rhos76319062rhos
rhus75114052rhus
seis45542392seis
shes75734352shes
shies86136552shies
shim95827862shim
shims104422552shims
shin75634312shin
shins85131042shins
ship95228242ship
ships105123772ships
shist84829612shist
shit76745942shit
shits84731172shits
shiv105721172shiv
shivs115018802shivs
shris84221452shris
sis37360542_sis
skis84825292skis
sris45434152sris
thin76732392thin
thins85826332thins
thio77225412thio
thir76420542thir
thus76721472thus
tis37056642_tis
tuis44829642tuis
vis66747612_vis
whid115418872whid
whids125413982whids
whig115516422whig
whigs125612642whigs
whim126220532whim
whims134515332whims
whin105225692whin
whins114922332whins
whip125521842whip
whips134917082whips
whir105519282whir
whirs115218092whirs
whish144512922whish
whisk154510142whisk
whist115322952whist
whit104834172whit
whits115923822whits
whiz195919942whiz
whys137011662whys
wis66552332_wis
xis106935332_xis
ywis105313102ywis

Search took 2 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 Filter178691298720.296603685.8
2DLD Change Limit298721970.80037340.0
3Display Results1971970.0464282.6
 (SQL Overall)1786911971.142156472.0
 
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.