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

170 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
shroffs163436(None) 
shroff1538501shroff_
scoffs14347502s_coffs
scruffs1554172scruffs
setoffs1334132setoffs
sheriffs17253922sheriffs
showoffs2042452showoffs
shrifts1335962shrifts
shroffed1842562shroffed
shrouds1136022shrouds
shutoffs1752072shutoffs
boffs134915503__boffs
buyoffs1842433buyoffs
chaffs17459613ch_affs
chromas142512693chromas
chromes142914933chromes
chromos142610273chromos
chuffs17427783ch_uffs
coffs134916303__coffs
crofts114910593_crofts
cutoffs1533603cutoffs
dieoffs1443033dieoffs
doffs125614333__doffs
draffs13617903_draffs
feoffs1163703_feoffs
flyoffs1542253flyoffs
griffs13398993_griffs
gruffs13337453_gruffs
hoofs115721043_h_oofs
howffs18535043_howffs
howfs144814503_h_owfs
huffs144514743_h_uffs
layoffs1642573layoffs
offs107117013___offs
payoffs1843243payoffs
profs105120893_pro_fs
proofs114511683_proofs
putoffs1543333putoffs
raffs115017523__raffs
reroofs1037943reroofs
riffs115114613__riffs
ripoffs1543383ripoffs
rolfs84817123__rolfs
roofs85321153__roofs
ruboffs1543123ruboffs
ruffs114516743__ruffs
runoffs1343013runoffs
sarodes84216143sarodes
sarods74918573saro_ds
sarongs84511803sarongs
saros55238063saro__s
saroses73619333saroses
schrods1337433schro_ds
sclaffs1543573sclaffs
scoff134413343s_coff_
scrods94111603scro_ds
scrolls938063scrolls
scroops11288243scroops
scruff1437963scruff_
scruffy1842643scruffy
scuffs14419053s_cuffs
selloffs1443633selloffs
sendoffs1543493sendoffs
serfs84922013ser__fs
serifs94017053ser_ifs
serosas7312663serosas
serous65023563sero_us
serows96016393sero_ws
setoff1238913setoff_
shadoofs1554233shadoofs
shadufs1433673shadufs
shafts125411443sh_afts
sharifs13279903sharifs
sheafs124912883sh_eafs
sheols94614163sheo_ls
shereefs1433863shereefs
sheriff16287693sheriff_
sherifs13299683sherifs
sheroots1137863sheroots
shifts124412943sh_ifts
shlocks16317183shlocks
shmoes114612103shmo_es
shnooks1485583shnooks
shoals94215793sh_oals
shoats94117083sh_oats
shocks154414583sh_ocks
shoers94518333sh_oers
shoes85429663sh_o_es
shofar1236313sh_ofar
shofars1335833sh_ofars
shogis103810943sh_ogis
shogs95319713sh_o_gs
shojis16348493sh_ojis
shoofly1634353shoofly
shooks134515633sh_ooks
shools94919013sh_ools
shoos84226363sh_o_os
shoots94619363sh_oots
shops104222903sh_o_ps
shorans102812413shorans
shores94830413sh_ores
shorls94516203sh_orls
shorts95321743sh_orts
shotes95321913sh_otes
shots84730853sh_o_ts
shotts93614703sh_otts
shouts94017723sh_outs
shoves124919423sh_oves
showoff1943893showoff_
shows115324583sh_o_ws
shoyus1266003sh_oyus
shreds105613053shr_eds
shrews129313913shr_ews
shrieks14377673shrieks
shrift12413543shr_ift
shrikes144412393shrikes
shrills10389933shrills
shrimps14516753shrimps
shrines104618693shrines
shrinks14397913shrinks
shris84221453shr__is
shrives134416173shrives
shroffing1943313shroffing
shroud1038773shro_ud
shrove125412233shro_ve
shrubs11409213shr_ubs
shrugs10469163shr_ugs
shutoff1693203shutoff_
skiffs16327013s_kiffs
sluffs12349583s_luffs
sniffs12378843s_niffs
snuffs12358533s_nuffs
sofas85320713s__ofas
softs85019233s__ofts
soroses73117483soroses
sorosis72611973sorosis
spiffs14328473s_piffs
spinoffs1642773spinoffs
spliffs1533563spliffs
spoofs114011813s_poofs
sprouts949983sprouts
staffs12349753s_taffs
stiffs12389963s_tiffs
stopoffs1662993stopoffs
strafes104516003strafes
strifes104716583strifes
strobes93813263strobes
strokes114316323strokes
strolls739183strolls
strops86220383stro_ps
strouds837803strouds
strows96718273stro_ws
stroys95914603stro_ys
stuffs123810223s_tuffs
sunroofs1144763sunroofs
surfs85022543sur__fs
tariffs1334593tariffs
thrifts1335523thrifts
throats104612193throats
throbs118311373thro_bs
throes97518673thro_es
thrones105715843thrones
throngs11508163throngs
throws129715233thro_ws
tipoffs1543033tipoffs
toffs116016723__toffs
turnoffs1442833turnoffs
unroofs1035783unroofs
whiffs1835083wh_iffs
whoofs15457243wh_oofs

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.423422437.4
2DLD Change Limit1340271706.76319817.7
3Display Results1701700.0632698.4
 (SQL Overall)1786911707.24924650.4
 
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.