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

105 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
kaphs14491150(None) 
caphs124515371caphs
kapas116021731kapas
kaph135815751kaph_
khaphs18394321khaphs
kophs145010931kophs
aahs716428562_aahs
ahs68644822_a_hs
apes66047432_apes
aphis105917132_aphis
apos65433822_apos
apps86319692_apps
baps86040842bap_s
baths105922922baths
capes95441922capes
caph116623292caph_
capos94826072capos
caps87147892cap_s
dahs88231812da_hs
daps77239162dap_s
gapes86030822gapes
gaps76042972gap_s
graphs124510152graphs
hahs108333362ha_hs
haps96443462hap_s
japes146322822japes
kaas86531842ka_as
kabs107130842ka_bs
kadis105921062kadis
kaes85734062ka_es
kafs116423742ka_fs
kagus105812032kagus
kaifs125715642kaifs
kails95525212kails
kains96125642kains
kakas85117342kakas
kakis86116842kakis
kales95730982kales
kaliphs1634292kaliphs
kalpas124112942kalpas
kames115024692kames
kanas95326912kanas
kanes95529372kanes
kaons95014852kaons
kapa106021292kap_a
kapok10448782kapok
kapoks11347262kapoks
kappa13469742kappa
kappas144410362kappas
kaput11717062kaput
karns96624142karns
karts97630112karts
kas77058582ka__s
kasha124710722kasha
kashas133311902kashas
katas95922092katas
kats85944332ka_ts
kavas125919952kavas
kayos127714702kayos
kays116032192ka_ys
kepis115313362kepis
keps106027302kep_s
khaph17395962khaph_
kips106430512kip_s
kiths125814972kiths
knaps115511172knap_s
koph135816542koph_
kops107031292kop_s
lakhs125210342lakhs
lapis76223152lapis
laps66848872lap_s
laths86022402laths
machs125722562machs
maps86141042map_s
maths105624022maths
napas75924352napas
napes74828462napes
naps66238582nap_s
oaths86117312oaths
okapis1235392okapis
opahs105411982opahs
ouphs104311272ouphs
papas94927492papas
paps86443452pap_s
paths105521382paths
qophs19507812qophs
ralphs1135372ralphs
rapes75740722rapes
raphe104916422raphe
raphes115117452raphes
raphis114014322raphis
raps66247732rap_s
saps65346372sap_s
sophs104916022sophs
staphs114411032staphs
syphs13519452syphs
tachs105820932tachs
tapas74627712tapas
tapes75838602tapes
tapis75028862tapis
taps66050672tap_s
tophs105220052tophs
waps96642082wap_s
yaps95933522yap_s
zaps156826892zap_s

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 Filter178691538000.283631417.0
2DLD Change Limit538001055.6109590.0
3Display Results1051050.0761381.6
 (SQL Overall)1786911055.96929936.5
 
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.