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
bidis8672115(None) 
bides85536781bides
bidi78226601bidi_
bids75838461bid_s
bindis94614581bindis
midis85923421midis
abides94719892abides
aides65336612aides
aids57846372aid_s
bads77048872bad_s
basis75429862basis
bedim10313832bedim
bedims1149592bedims
beds75937792bed_s
bialis83617162bialis
bias64738172bi_as
bibbs84911582bibbs
bibs84831002bi_bs
bices95029962bices
bid67751822bid__
biddies113514492biddies
biddy124612702biddy
bide76041512bid_e
bided95424972bided
bider85728382bider
biders94822802biders
bidet84935632bidet
bidets95215532bidets
biding104720792biding
biers76225222biers
biffs134814412biffs
bifid11910702bifid
bigos85020012bigos
bigs76235032bi_gs
bikes117529472bikes
bikie113915882bikie
bikies124515162bikies
biles75542142biles
bilks115117892bilks
bills75632862bills
bimas95521742bimas
bindi85617022bindi_
binds86627482binds
bines76946792bines
binit76431582binit
binits85716672binits
bins66548262bi_ns
bints76130182bints
biogs85016112biogs
bios66335332bi_os
birdie94013782birdie
birdies104016212birdies
birds85421342birds
birks114920302birks
birls74023162birls
biros75325132biros
birrs74917102birrs
bis56860672b__is
bises75435622bises
bisks115416802bisks
bites75641172bites
bits66148172bi_ts
bitts75022592bitts
bizes165923662bizes
blinis85313682blinis
bodes84935102bodes
bodies94524142bodies
bods76244722bod_s
brides94423512brides
bris65539612b_ris
buds75235182bud_s
cadis84428502cadis
cedis84317082cedis
didie74120572didie
didies84621832didies
didos76820822didos
dis46459902__dis
eidos65817762eidos
fidos95819062fidos
fids87034752fid_s
finis86824262finis
gadis74825292gadis
gids65933752gid_s
hides95129432hides
ibis66519582_ibis
ides57734242_ides
ids47535482_id_s
iris45732552_iris
iwis77117012_iwis
kadis105921072kadis
kids96029652kid_s
kiwis12328592kiwis
lidos65219892lidos
lids56336472lid_s
midi75628492midi_
mids76541802mid_s
minis75432992minis
mitis75425992mitis
nides65229142nides
nidi56524412nidi_
nidus65913582nidus
oidia6314962oidia
padis86227142padis
pikis115116392pikis
pilis75825202pilis
qadis155917852qadis
rides66140822rides
rids56539562rid_s
sadis64930852sadis
sides65838372sides
tides64830162tides
tidies74721832tidies
tikis95615972tikis
tipis76019922tipis
titis56023812titis
vids85627552vid_s
wadis95223962wadis
wides94832832wides
widish13419362widish
yids85224972yid_s
zitis145815582zitis

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 Filter178691538000.716249568.4
2DLD Change Limit538001216.7667951.5
3Display Results1211210.203596.1
 (SQL Overall)1786911217.68523251.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.