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

116 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
indaba93563(None) 
indabas1045851indabas
aba512850953___aba
anabas8314083an_abas
baba88828353__baba
bandana10179463bandana
bindable13169623bindable
casaba1079263casaba
cinnabar1282553cinnabar
dab67455563__dab_
dabs77139403__dabs
dada66422443__dada
data56026653__data
endameba1352933endameba
endash10297123endash
findable14179023findable
idea59122773i_d_ea
iguana735813iguana
impala10256933impala
inane52820343in_ane
inapt73522693in_apt
inarm7314423in_arm
inby95315663in__by
incage93513623incage
incant82418503incant
incase83615283incase
incubi1035113incubi
indagate1047193indagate
indamin1048043indamin
indeed83913563indeed
indene73215373indene
indent73021243indent
index13310983ind_ex
indican1048243indican
indicia1046983indicia
indict93115573indict
indie63721473ind_ie
indies73822783indies
indign8308473indign
indigo8388023indigo
indite73520323indite
indium939503indium
indol63714873ind_ol
indole74516053indole
indols74714203indols
indoor738403indoor
indow95011663ind_ow
indows104210793indows
indraft1199563indraft
indrawn1145093indrawn
indri6310793ind_ri
indris7311963indris
induce93811533induce
induct93212743induct
indue63516673ind_ue
indued83411653indued
indues73515263indues
indult73614033indult
indusia845653indusia
inedita846793inedita
infall939403infall
infamy1435653infamy
infant92315133infant
infanta10237253infanta
infare9313083infare
infauna1044403infauna
infra838643in_fra
ingate73018243ingate
inhabit1277403inhabit
inhale9411513inhale
inhaul936803inhaul
inia45024703in__ia
inlace82513043inlace
inlaid7310143inlaid
inland7310313inland
inlay85214323inla_y
inlays9389873inlays
inmate82917363inmate
innage73011573innage
innate63917313innate
insane6314883insane
intact8314663intact
intake10510863intake
intima81910033intima
invade10157853invade
invar839513inva_r
invars9310003invars
inwall938343inwall
inward10310333inward
iodate7313503iodate
isba61310883i__sba
jnana12159043jn_ana
kinara10310373kin_ara
lindane839033lindane
mandala10310213mandala
medaka1336343medaka
nab56954923_n_ab_
nabe66029493_n_abe
nabs66236193_n_abs
nada58022903_n_ada
nala46930393_n_ala
nana46632893_n_ana
napa66927263_n_apa
nidal65217103nida_l
nidate7313783nidate
nyala836823_nyala
piasaba1144193piasaba
pinata83817223pin_ata
pintada1096083pintada
qindar16317173qinda_r
qindarka2241923qindarka
qindars17267423qindars
windable14159153windable
windage1237933windage
windbag1444123windbag
zingara1745513zingara

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 Limit1127161165.53020382.6
3Display Results1161160.0462521.7
 (SQL Overall)1786911165.71631261.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.