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

99 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
baizes17431505(None) 
baizas173810821baizas
baize164717391baize_
bizes165923661b_izes
braizes183112451braizes
maizes175115731maizes
abides94719892abides
adzes155913802_adzes
aides65336612_aides
baases85218012baases
babes95834112ba_bes
babies106123652babies
baches135426942baches
badges103917372badges
bailed94726652bailed
bailee84526012bailee
bailees93914382bailees
bailer85425252bailer
bailers94221352bailers
bailey115015672bailey
baileys12388932baileys
bailies94120202bailies
bails75933522bai_ls
bairns86710872bairns
baited95319242baited
baiter84422562baiter
baiters94619312baiters
baits76630582bai_ts
baiza164813222baiz_a
bakes117035372ba_kes
bales76250082ba_les
banes74945582ba_nes
baptizes2136842baptizes
barbes104526232barbes
bardes95026932bardes
bares75457132ba_res
barges94528252barges
barites94322332barites
barres84427552barres
baryes116218502baryes
bases75644352ba_ses
bashes115631392bashes
basses85428302basses
bastes85330382bastes
bates75846342ba_tes
bathes116524832bathes
beiges91014412beiges
biases84618432biases
bices95029962b_ices
bides85536782b_ides
bikes117529472b_ikes
biles75542142b_iles
bines76946792b_ines
bises75435622b_ises
bites75641172b_ites
bize155926302b_ize_
bizzes163910842bizzes
blazes174817352blazes
blites84721212blites
blitzes18408702blitzes
boites84322702boites
bonzes175116102bonzes
boozes174916522boozes
braises93818872braises
braize174113112braize_
brazes175522192brazes
bribes105918532bribes
brides94423512brides
bries74942152bri_es
brines85028852brines
brises84927612brises
buzzes165011172buzzes
capizes20410372capizes
daises74318982daises
dazes155024142da_zes
fazes175527212fa_zes
frizes184015462frizes
gauzes164710632gauzes
gazes155425912ga_zes
hafizes2235982hafizes
hazes174928322ha_zes
jazzes21347882jazzes
lazes145129572la_zes
lazies154418782lazies
mailes84329112mailes
maize164618562maize_
mazes165632172ma_zes
naives94914222naives
phizes20389132phizes
prizes173819812prizes
raises64826542raises
razes145032702ra_zes
razzes144910072razzes
saices84221802saices
seizes154317532seizes
sizes146727762_sizes
waives123714182waives
wizes174723342_wizes
zaires1539702zaires

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit82551992.57632046.2
3Display Results99990.0333000.0
 (SQL Overall)178691992.95260532.2
 
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.