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

101 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
gazebos193349(None) 
gazabos1944451gazabos
gazebo1833671gazebo_
gazeboes2043391gazeboes
gazabo1834832gazabo_
gazaboes2043862gazaboes
gazers164516302gaze_rs
gazes155425912gaze__s
gazoos163010222gaz_oos
jazzbos2442032jazzbos
abos67734413_a__bos
adobos9438453_adobos
ambos95321253_a_mbos
amebas10311453_amebas
azygos1933333_azygos
bazoos173212623baz_oos
cameos105818003came_os
carbos105122263ca_rbos
dazes155024143daze__s
ephebos1444113ephebos
farebox1943823farebox
fazes175527213faze__s
gabbers124612833gabbers
gabbros12124653gabbros
gabs76740423ga__b_s
gaes56348033ga_e__s
gagers84021333gage_rs
gages74529973gage__s
galagos938143galagos
galeas74618513gale_as
galenas83310343galenas
galeres83514333galeres
gales65442483gale__s
gambas115817513ga_mbas
gambes116318313ga_mbes
gambol1138223ga_mbol
gambols1238593ga_mbols
gambs105721123ga_mb_s
gamers94420833game_rs
games86238553game__s
gametes10312253gametes
ganefs10489203gane_fs
ganevs10456913gane_vs
gapers94520473gape_rs
gapes86030823gape__s
garbs86321413ga_rb_s
gaseous839503gaseous
gases65633993gase__s
gateaus866333gateaus
gatepost1145443gatepost
gaters74728643gate_rs
gates65939513gate__s
gauchos1345903gauchos
gauzes164710633gauze__s
gavels105911093gave_ls
gazars164811553gaz_ars
gaze145032413gaze___
gazed165520333gaze__d
gazelle17236333gazelle
gazelles18266563gazelles
gazer155720073gaze__r
gazette17357363gazette
gazettes18296863gazettes
gazoo153112873gaz__oo
gazumps2131873gazumps
gizmos1844133giz_mos
glazers174410043glaze_rs
glazes165315643glaze__s
glebes95512243g_lebes
gobos86219383g__obos
gombos114311093g_ombos
grazers175112453graze_rs
grazes164519643graze__s
grebes93813613g_rebes
gregos847533g_regos
gumbos114610873g_umbos
hazels185710083haze_ls
hazers184615953haze_rs
hazes174928323haze__s
jazzbo2342713jazzbo_
kazoos19259113kaz_oos
lavabos1235453lavabos
lazes145129573laze__s
mambos125414493ma_mbos
mazers173917093maze_rs
mazes165632173maze__s
pageboy1543873pageboy
pageboys1643183pageboys
pareos87023773pare_os
paseos88015813pase_os
placebos1443713placebos
razees154314763raze_es
razers154919613raze_rs
razes145032703raze__s
rezeros1647453rezeros
sambos104315193sa_mbos
wazoos18288553waz_oos
zarebas1836303zarebas
zazens1435833zaze_ns
zebus164610053__zebus
zeros144918113__zeros

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.403443402.0
2DLD Change Limit1340271016.92319359.7
3Display Results1011010.0333060.6
 (SQL Overall)1786911017.35924282.0
 
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.