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 “kepis” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
kepis11531336(None) 
kepi105315631kepi_
keps106027301kep_s
aegis6316782aegis
aspis74618142aspis
cedis84317082cedis
cepes94424462cepes
ceps86125952cep_s
defis96717502defis
delis64928542delis
egis56520652_egis
epic86921302_epic
epics95014282_epics
epos66723732_epos
impis96213852impis
kadis105921062kadis
kakis86116842kakis
kapas116021732kapas
kaphs144911502kaphs
keas86337092ke_as
kecks105416572kecks
keefs125116282keefs
keeks84717252keeks
keels94622412keels
keens95721182keens
keeps116020282keeps
keets95123482keets
kefir12457912kefir
kefirs13396652kefirs
kefs115922742ke_fs
kegs95824012ke_gs
keir86217872ke_ir
keirs95313672keirs
kelim11912542kelim
kelims1278912kelims
kelpie12308612kelpie
kelpies13289902kelpies
kelps115116422kelps
kelts95222632kelts
kemps135012522kemps
kenos95220622kenos
kens85435232ke_ns
kep96437202kep__
kept106232942kep_t
kerbs115013672kerbs
kerfs125413572kerfs
kermis124012392kermis
kerns94719562kerns
kevil12399862kevil
kevils13358332kevils
kewpie15465412kewpie
kewpies16246922kewpies
kexes166216812kexes
keys116322162ke_ys
khis117017982k_his
kips106430512kip_s
kis78051472k__is
kiwis12328582kiwis
kois85129392k_ois
kojis16468432kojis
kophs145010932kophs
kops107031292kop_s
kris86423602k_ris
kufis1249252kufis
lapis76223152lapis
leis45739602le_is
lenis56326862lenis
levis85818552levis
lewis85315842lewis
lexis125916032lexis
metis75025902metis
okapis1235392okapis
penis75129322penis
pepos96620082pepos
peps85134512pep_s
peris75537072peris
pis56362032__pis
reis45343232re_is
repin75324702repin
repins84924312repins
repos74725792repos
repps95114342repps
reps65937952rep_s
seis45542392se_is
semis74623532semis
sepia75318672sepia
sepias83616102sepias
sepic94617052sepic
sepsis83011292sepsis
septs75420602septs
skeps115614252skep_s
skepsis1344242skepsis
tapis75028862tapis
tepas76521682tepas
tepid8314312tepid
tipis76019922tipis
topis76025832topis
yeps95924402yep_s
yetis85418392yetis
zeps156019342zep_s

Search took 5 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.186960704.3
2DLD Change Limit538001004.20312800.4
3Display Results1001000.0333030.3
 (SQL Overall)1786911004.42240409.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.