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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

137 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
schtiks1618474(None) 
schriks16185741schriks
schticks19193951schticks
schtik15185411schtik_
shtiks13297821s_htiks
schrik15206702schrik_
schtick18194522schtick
schuits1235822schuits
scotias939742scotias
sheiks132510012s_heiks
shticks16356962s_hticks
shtik123210952s_htik_
acetins9313173acetins
actins86321103ac_tins
ascetics1247073ascetics
batiks1239373_batiks
battiks1337143battiks
chains114819703_chains
chairs114916183_chairs
chais107530313_chai_s
chalks155412143_chalks
charks155219703_charks
checks174912703_checks
cheeks154712783_cheeks
chias104625523_ch_ias
chicks175317593_chicks
chics123920943_ch_ics
chinks155817573_chinks
chins105631463_ch_ins
chips125721253_ch_ips
chirks155414843_chirks
chis95933313_ch_i_s
chitins122713793_chitins
chits105424573_ch_its
chocks174815313_chocks
choirs114911883_choirs
chooks155312793_chooks
chucks174812933_chucks
chunks154210333_chunks
cities84524853_cities
cuties84927363_cuties
cutins83919983_cutins
cutis77723763_cuti_s
haiks125120933__haiks
sahibs1137083sah_ibs
salties73725773salties
santims9312593santims
santirs7312963santirs
satins64930483s_atins
satis55633673s_ati_s
scabies11613333scabies
scanties103215423scanties
scathes124515713scathes
scats75930603scat__s
scatts85914663scat_ts
scenics1137773scenics
sceptics1455663sceptics
schavs1436493sch_avs
schemas1468163schemas
schemes1489663schemes
schism1338173sch_ism
schisms1437173schisms
schist11312653sch_ist
schists1248543schists
schizo20115993sch_izo
schizos21115433schizos
schizy23115043sch_izy
schleps1445483schleps
schlocks19245693schlocks
schlubs1443193schlubs
schmoes14308543schmoes
schmoos14347513schmoos
schmos13379153sch_mos
schmucks2142763schmucks
schnaps1443703schnaps
schnooks1754243schnooks
schools1249113schools
schorls1248353schorls
schrods1337433schrods
schuit1139563schui_t
schuls11299853sch_uls
schuss11186733sch_uss
schwas14396983sch_was
sciatics12117273sciatics
scoters93313803scoters
scotia8310793scoti_a
scots74025903scot__s
scotties1039743scotties
screaks13469353screaks
scries85226823sc_ries
scrims104615933sc_rims
scrips105316033sc_rips
sculks123610263sc_ulks
scutes85219193scut_es
scuts74522523scut__s
scythes15356523scythes
septics112810433septics
shacks154817563s_hacks
shanks135315583s_hanks
sharks135019723s_harks
sheik122514653s_heik_
sheikh16206993s_heikh
sheikhs17233993s_heikhs
shies86136553s_h_ies
shiksa1394653s_h_iksa
shikse1386073s_h_ikse
shims104422543s_h_ims
shins85131043s_h_ins
ships105123773s_h_ips
shirks134814123s_hirks
shits84731163s_h_its
shivs115018803s_h_ivs
shocks154414573s_hocks
shooks134515623s_hooks
shrieks14377673s_hrieks
shrike134513243s_hrike
shrikes144412393s_hrikes
shrinks14397913s_hrinks
shris84221443s_hri_s
shtick15308013s_htick
shticky19344473s_hticky
shucks154010413s_hucks
sixties14310973sixties
softies103414613softies
sorties74126403sorties
spiks114117473s__piks
sputniks1462093sputniks
statics93314533statics
statins73719773statins
sticks125118613s__ticks
sties55132983s__ties
stinks105616833s__tinks
stirks104914243s__tirks
stirs55921623s__tirs
stotins73213863stotins
suchlike1735123suchlike
susliks1136443susliks

Search took 8 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271377.07618941.1
3Display Results1371370.0462978.3
 (SQL Overall)1786911377.27824552.2
 
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.