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

121 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
bidis8672114(None) 
bides85536771bides
bidi78226591bidi_
bids75838451bid_s
bindis94614581bindis
midis85923411midis
abides94719892abides
aides65336602aides
aids57846362aid_s
bads77048862bad_s
basis75429862basis
bedim10313832bedim
bedims1149592bedims
beds75937782bed_s
bialis83617162bialis
bias64738162bi_as
bibbs84911582bibbs
bibs84830992bi_bs
bices95029962bices
bid67751812bid__
biddies113514492biddies
biddy124612692biddy
bide76041502bid_e
bided95424962bided
bider85728372bider
biders94822802biders
bidet84935622bidet
bidets95215532bidets
biding104720792biding
biers76225222biers
biffs134814412biffs
bifid11910702bifid
bigos85020012bigos
bigs76235022bi_gs
bikes117529472bikes
bikie113915882bikie
bikies124515162bikies
biles75542142biles
bilks115117892bilks
bills75632862bills
bimas95521742bimas
bindi85617012bindi_
binds86627472binds
bines76946792bines
binit76431582binit
binits85716672binits
bins66548252bi_ns
bints76130182bints
biogs85016112biogs
bios66335322bi_os
birdie94013782birdie
birdies104016212birdies
birds85421332birds
birks114920302birks
birls74023162birls
biros75325132biros
birrs74917102birrs
bis56860662b__is
bises75435622bises
bisks115416802bisks
bites75641172bites
bits66148162bi_ts
bitts75022592bitts
bizes165923662bizes
blinis85313682blinis
bodes84935102bodes
bodies94524142bodies
bods76244712bod_s
brides94423512brides
bris65539612b_ris
buds75235172bud_s
cadis84428502cadis
cedis84317082cedis
didie74120562didie
didies84621832didies
didos76820812didos
dis46459892__dis
eidos65817752eidos
fidos95819052fidos
fids87034742fid_s
finis86824262finis
gadis74825292gadis
gids65933742gid_s
hides95129422hides
ibis66519582_ibis
ides57734232_ides
ids47535472_id_s
iris45732552_iris
iwis77117012_iwis
kadis105921062kadis
kids96029642kid_s
kiwis12328582kiwis
lidos65219882lidos
lids56336462lid_s
midi75628482midi_
mids76541792mid_s
minis75432992minis
mitis75425992mitis
nides65229132nides
nidi56524402nidi_
nidus65913572nidus
oidia6314952oidia
padis86227142padis
pikis115116392pikis
pilis75825202pilis
qadis155917852qadis
rides66140812rides
rids56539552rid_s
sadis64930852sadis
sides65838362sides
tides64830152tides
tidies74721832tidies
tikis95615972tikis
tipis76019922tipis
titis56023812titis
vids85627542vid_s
wadis95223962wadis
wides94832822wides
widish13419362widish
yids85224962yid_s
zitis145815582zitis

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 Limit538001211.37639098.8
3Display Results1211210.0304033.3
 (SQL Overall)1786911211.719103950.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.