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

112 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
gazabo183483(None) 
gazabos1944451gazabos
gazebo1833671gazebo
galago838902galago
gazaboes2043862gazaboes
gazar154612982gaza_r
gazars164811552gazars
gazebos1933492gazebos
gazoo153112872gaz_oo
jazzbo2342712jazzbo
lavabo1135272lavabo
abo59045963___abo
adobo84711593_adobo
alamo7418143_alamo
ambo88225143_a_mbo
azan136521783_aza_n
azans146516883_azans
azido155411543_azido
azo128233393_az__o
bayamo1335603bayamo
bazaar17306403bazaar
bazar163816003baza_r
bazars174613113bazars
bazoo163815673baz_oo
cacao95420003caca_o
carabao1139673carabao
carbo94923843ca_rbo
casaba1079263casaba
catalo8314853catalo
gab67155993g__ab_
gabbro11114953gabbro
gabby135512953ga_bby
gabs76740423g__abs
gaby107123193g__aby
gadabout1245563gadabout
gadjo1436913ga_djo
gaga66625553gaga__
gagaku1243813gagaku
gala55635163gala__
galabia1038323galabia
galagos938143galagos
galah95917633gala_h
galahs105512673galahs
galas65731643gala_s
galax135314463gala_x
galaxy17476313galaxy
gama77035523gama__
gamas85431363gama_s
gamay116419113gama_y
gamays126310913gamays
gamb96331843ga_mb_
gamba106018513ga_mba
gambado1344973gambado
gambas115817513gambas
gambe106219213ga_mbe
gambol1138223ga_mbol
gambs105721123ga_mbs
garage8314513garage
garb75332673ga_rb_
garbs86321413ga_rbs
gasbag1035413gasbag
gaucho1256223gaucho
gavage1137193gavage
gayal9312713gaya_l
gayals1039513gayals
gazania1746123gazania
gaze145032413gaz__e
gazeboes2043393gazeboes
gazed165520333gaz_ed
gazer155720073gaz_er
gazers164516303gazers
gazes155425913gaz_es
gazing174717173gazing
gazoos163010223gazoos
gazpacho2551263gazpacho
gazump2032453gazump
gelato73812953gelato
gitano738043gitano
gizmo1756013giz_mo
gobo76126903g__obo
gombo105814043g_ombo
grab75427613g_rab_
grabs85719693g_rabs
grazable2036223grazable
guaco85012163g_uaco
guanaco1064583guanaco
guano69213983g_uano
gumbo104413583g_umbo
hazan173813613haza_n
hazans183411653hazans
hazard1938403hazard
jazzbos2442033jazzbos
kabab134814443kabab_
kababs14409773kababs
kakapo1143853kakapo
kazoo183311533kaz_oo
lavabos1235453lavabos
lazar144113643laza_r
lazars153812393lazars
macaco1247853macaco
mambo115215743ma_mbo
marabou1147493marabou
mazard1838763mazard
nawab10810923nawab_
nawabs1185063nawabs
paramo102614643paramo
pazazz1554023pazazz
rabato83413263rabato
sambo95118013sa_mbo
tapalo839793tapalo
wasabi1154643wasabi
wazoo173011173waz_oo

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127161125.42020796.3
3Display Results1121120.0462434.8
 (SQL Overall)1786911125.84230587.3
 
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.