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

89 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
bitsy10451130(None) 
bits66148151bits_
bitty106119171bitty
ditsy95612561ditsy
aits46355532aits_
antsy85712792antsy
artsy86012962artsy
baits76630582baits_
bassy1012917102bassy
bats66962332bats_
batty105422242batty
bets67051442bets_
bialy105119322bialy
bias64738152bias_
bibs84830972bibs_
biddy124612692biddy
bids75838422bids_
biffy164711122biffy
biggy124413132biggy
bigly114814752bigly
bigs76235012bigs_
bilby124912342bilby
bilgy114713712bilgy
billy105525362billy
bins66548242bins_
bints76130182bints_
biopsy1334532biopsy
bios66335312bios_
birse74517402birse
bis56860652bi_s_
bise66437092bi_se
bisk106523342bi_sk
bit57070892bit__
bitch125017762bitch
bitchy16479202bitchy
bite66546992bit_e
biter75030032biter
bites75641172bites
bitt65545802bit_t
bitts75022592bitts
bossy105515972bossy
bothy136713962bothy
bots66453952bots_
bousy104917842bousy
brits76433082brits_
brosy106115382brosy
busty105621012busty
busy94727172b_usy
buts67247692buts_
butty104020112butty
cissy104811072cissy
city95122622cit_y
dits56450522dits_
ditty95019292ditty
ditzy186513282ditzy
fitly115114972fitly
fits76043462fits_
gipsy11579542gipsy
gits55744592gits_
gutsy96412842gutsy
hissy116112122hissy
hits75545132hits_
its35538832_its_
kissy125510312kissy
kits86441762kits_
kitty124614562kitty
lits46252492lits_
missy105617562missy
misty106120452misty
mity95528202mit_y
nits45741642nits_
nitty85418312nitty
nutsy85711502nutsy
obits74617542obits_
patsy105717202patsy
pithy135614462pithy
pits66348742pits_
pity96031932pit_y
potsy105815612potsy
ritzy175611162ritzy
sissy85812072sissy
sits45050202sits_
tipsy106010502tipsy
tits46145032tits_
titty85316652titty
withy144813762withy
wits76044872wits_
witty114717012witty
zits136030292zits_

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.0931921408.6
2DLD Change Limit53800891.59333772.8
3Display Results89890.0302966.7
 (SQL Overall)178691891.716104132.3
 
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.