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

101 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
shift11422514(None) 
shaft115725261shaft
shifts124412941shifts
shifty15409261shifty
shirt84533901shirt
shist84829611shist
shit76745941shi_t
shrift12413541shrift
sift710740661s_ift
swift116818051swift
chit96937462chi_t
clift106422192clift
drift95722842drift
gift86735792_gift
grift95924462grift
haft105941842_haft
heft106736292_heft
hilt75850712_hilt
hint77455742_hint
hist76551542_hist
hit66569192_hi_t
lift76942722_lift
rift75642332_rift
saint55147072saint
schist11312652schist
seif75638732seif_
seifs85019332seifs
shafts125411442shafts
shalt85534492shalt
shat76456602sh_at
sheet84836962sheet
shent85933502shent
shied96125492shied
shiel811023772shiel
shier85428942shier
shies86136552shies
shiest95821522shiest
shifted14359982shifted
shifter132911082shifter
shill85325332shill
shily115222012shily
shim95827862shi_m
shims104422552shims
shin75634312shi_n
shine85533092shine
shins85131042shins
shiny115122142shiny
ship95228242shi_p
ships105123772ships
shire84727132shire
shirk124817842shirk
shirr84716922shirr
shirts94918342shirts
shirty124312562shirty
shists96515112shists
shits84731172shits
shitty124110062shitty
shiv105721172shi_v
shiva115915002shiva
shive114423422shive
shivs115018802shivs
shoat85633952shoat
shoot84235912shoot
short85040532short
shot76150262sh_ot
shott85332192shott
shout85433172shout
shrifts1335962shrifts
shunt85226512shunt
shut76137592sh_ut
sifts84918922s_ifts
silt46558192s_ilt
sit35877752s_i_t
skiff153612802skiff
skint95629222skint
skirt95624662skirt
skit85437532ski_t
slipt76627482slipt
slit46250102sli_t
smit65138412smi_t
sniff113915862sniff
snit46342472sni_t
soft76942822s_oft
spiff133616402spiff
spilt75532222spilt
spirt75032952spirt
spit65545082spi_t
stiff114219242stiff
stilt54831982stilt
stint57037662stint
suint55638182suint
suit45649872sui_t
swifts12408172swifts
theft114118132theft
thrift12412042thrift
unshift1387412unshift
upshift1545112upshift
whiff17310062whiff
whipt135317422whipt
whist115322952whist
whit104834172whi_t

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.296603685.8
2DLD Change Limit538001011.37639098.8
3Display Results1011010.0166312.5
 (SQL Overall)1786911011.688105859.6
 
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.