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 “gaijio” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

84 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
gaijin1445981gaijin
daimio937462daimio
gadjo1436912gadj_o
agio57828453_a_gio
aikido1135473_aikido
amnio75218053_amnio
audio62917103_audio
bagnio937523bagnio
bailie83818363bailie
banjo143812443banj_o
barrio8312573barrio
cardio9915673cardio
daimios1035753daimios
daimyo1233193daimyo
danio6319783da_nio
gabbro11114953gabbro
gabion93211033ga_bion
gaddi85211633gaddi_
gaddis94211373gaddis
gadi66329723ga_di_
gadid85517383ga_did
gadis74825293ga_dis
gadje1457743gadj_e
gadoid9310463gadoid
gaiety10119373gaiety
gaily95020973gai_ly
gain56042163ga__in
gained84617463gained
gainer74117493gainer
gaining94015663gaining
gainly1049323gainly
gains65729513gai_ns
gainst74914693gainst
gait56150193ga__it
gaited84416923gaited
gaiter73819503gaiter
gaiting93716583gaiting
gaits65726013gai_ts
galago838903galago
galiot72322593ga_liot
gallic9411643gallic
galliot82214133galliot
gambia115912253gambia
gambir11509773gambir
gambit114714213gambit
gamic103916203ga_mic
gamin84423003ga_min
ganja131410003ganj_a
ganjah17145503ganjah
ganjas14149113ganjas
ganoid8314443ganoid
garlic9310043garlic
garni6315703garni_
gaskin113610583gaskin
gaslit7513503gaslit
gaucho1256223gaucho
gawsie1038463gawsie
gazabo1834833gazabo
gazebo1833673gazebo
gazoo153112873ga_zoo
ginzo1539613g_inzo
giro55828633g_i_ro
gismo848863g_ismo
gizmo1756013g_izmo
glaikit1244633glaikit
gringo838643gringo
guiro63712093gui_ro
hadji16839893hadji_
hadjis17439653hadjis
hairdo1036433hairdo
haji148520193ha_ji_
hajis156716283ha_jis
hajji14677463hajji_
hajjis15485893hajjis
kainit10414483kainit
kanji1647453kanji_
kanjis1735963kanjis
masjid16187323masjid
patio74426353pa_tio
radio64922493ra_dio
raisin62716923raisin
ratio55227583ra_tio
saimin8313663saimin
saiyid10167413saiyid

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.1401276364.3
2DLD Change Limit112716845.64319974.5
3Display Results84840.0302800.0
 (SQL Overall)178691845.81330739.9
 
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.