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

156 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
shist8482961(None) 
hist76551541_hist
schist11312651schist
shiest95821521shiest
shift114225141shift
shirt84533901shirt
shists96515111shists
shit76745941shi_t
shits84731171shits
whist115322951whist
agist66325582agist
ahis76135382ahis_
alist56136782alist
ashiest10313952ashiest
assist6314602assist
chest104926142chest
chis95933312chis_
chit96937462chi_t
chits105424572chits
cist67244962_cist
deist64633592deist
exist124618942exist
feist86230072feist
fist76248422_fist
foist85730972foist
ghast95621222ghast
ghis85020162ghis_
ghost96318762ghost
gist56046762_gist
grist65529872grist
hast76259482_hast
heist87030912heist
hest75950772_hest
hilt75850712_hilt
hint77455742_hint
his66359502_his_
hisn79620932_hisn
hiss75629212_hiss
hists86328372_hists
hit66569192_hi_t
hits75545132_hits
hoist86433212hoist
host77852832_host
joist125125652joist
khis117017982khis_
kist86540802_kist
list47055342_list
maist75535682maist
mist66154532_mist
moist76033582moist
neist54628442neist
odist6421912odist
phis95724902phis_
sadist74221352sadist
saint55147072saint
sayst85322002sayst
schism1338172schism
schists1248542schists
seis45542392seis_
seise54727852seise
seism75019022seism
sexist133013482sexist
shaft115725272shaft
shalt85534492shalt
shat76456602sh_at
sheet84836962sheet
shent85933502shent
shes75734352shes_
shied96125492shied
shiel811023772shiel
shier85428942shier
shies86136552shies
shifts124412942shifts
shifty15409262shifty
shiksa1394652shiksa
shikse1386072shikse
shill85325332shill
shily115222012shily
shim95827862shi_m
shims104422552shims
shin75634312shi_n
shine85533092shine
shins85131042shins
shiny115122142shiny
ship95228242shi_p
ships105123772ships
shire84727132shire
shirk124817842shirk
shirr84716922shirr
shirts94918342shirts
shirty124312562shirty
shitty124110062shitty
shiv105721172shi_v
shiva115915002shiva
shive114423422shive
shivs115018802shivs
shoat85633952shoat
shoot84235912shoot
short85040532short
shot76150262sh_ot
shots84730852shots
shott85332192shott
shout85433172shout
shrift12413542shrift
shris84221452shris_
shunt85226512shunt
shush113812542shush
shut76137592sh_ut
shuts85622482shuts
shyest125511832shyest
sift710740662s_ift
silt46558192s_ilt
sis37360542s_is_
sit35877752s_i_t
sits45050202s_its
skint95629222skint
skirt95624662skirt
skis84825292skis_
skit85437532ski_t
skits94721862skits
sliest66621952sliest
slipt76627482slipt
slit46250102sli_t
slits56128852slits
smit65138412smi_t
snit46342472sni_t
snits54124832snits
sophist12311562sophist
spilt75532222spilt
spirt75032952spirt
spit65545082spi_t
spits74429552spits
sris45434152sris_
stilt54831982stilt
stint57037662stint
suint55638182suint
suit45649872sui_t
suits55028052suits
swift116818052swift
swish115114822swish
swiss86712902swiss
theist9314762theist
thirst9312252thirst
this76027382this_
twist86820982twist
waist86132382waist
whilst1239142whilst
whipt135317422whipt
whish144512922whish
whisht154510812whisht
whisk154510142whisk
whists124613812whists
whit104834172whi_t
whits115923822whits
wist78049292_wist
wrist84827562wrist

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 Filter178691538000.313570897.8
2DLD Change Limit538001561.50035866.7
3Display Results1561560.0463391.3
 (SQL Overall)1786911561.85996122.1
 
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.