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

140 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
giaours83457(None) 
giaour735361giaour_
gaurs66317992g_a_urs
glamours1184742glamours
miaous8511692miaou_s
rigours8207002rigours
vigours11285482vigours
amours83512663_amours
arbours93910043arbours
ardours8368883ardours
armours9389853armours
bijous1548043bijou_s
clamours1255993clamours
clours85215093_clours
colours95913443colours
detours858043detours
devours1166643devours
dialers83614303dialers
diapers104713913diapers
diapirs10347643diapirs
dimouts1037893dimouts
diseurs839403diseurs
dolours8438823dolours
dyvours1453183dyvours
enamours1044663enamours
faitours1134263faitours
favours13437093favours
fiars86720833fia__rs
flavours1434693flavours
flours94414053_flours
fours85521493__fours
gagers84021333g_agers
gainers84214593gainers
gaiters83516543gaiters
gamers94420833g_amers
gamuts958783g_amuts
gaolers83511563g_aolers
gaols66717573g_ao_ls
gapers94520473g_apers
gars55750743g_a__rs
gaters74728643g_aters
gators74115843g_ators
gauds75717723g_a_uds
gaums86217073g_a_ums
gaur56723353g_a_ur_
gauss65613453g_a_uss
gazars164811553g_azars
gazers164516303g_azers
gears64628693gea__rs
ghauts10447783gha_uts
ghouls1036043g_houls
giants74713503gia_nts
gibbers124710983gibbers
gibbous1265333gibbou_s
gibers95114663gi_bers
gigolos934693gigolos
gigots83911953gigo_ts
gigues8129003gi_gues
gilders94212463gilders
gillers84216903gillers
gingers94118643gingers
ginners84314223ginners
gipons9389603gipo_ns
gippers123212083gippers
girders9379943girders
girons75014373giro_ns
giros65722653giro__s
givers104817713gi_vers
glairs75211333gla_irs
glamors1068123glamors
glamour1065143glamour_
glazers174410043glazers
glouts74414713g_louts
gnarrs7407663gna_rrs
gnars66718853gna__rs
gnawers11356393gnawers
goers65520253g__oers
gourd71011903g__ourd
gourds8108253g__ourds
gouts64826173g__outs
graders94716013graders
gradus84411223gradu_s
graters85419743graters
gravers114515273gravers
gravure1134953gravure
gravures1234903gravures
grayouts1244693grayouts
grazers175112453grazers
groups94210513g_roups
grouts75015613g_routs
guars65021053gua__rs
hiatus938223hiatu_s
honours10339373honours
hours85422393__hours
humours1286433humours
incurs83012283_incurs
inpours936423inpours
knaurs10466963kna_urs
labours9349893labours
liars54723163lia__rs
liquors1634433liquors
lours55125293__lours
miaou7513083miaou__
miaoued1034583miaoued
miaows1145473miao_ws
miauls8178713mia_uls
minors85117103mino_rs
odours7418253_odours
ours47237563___ours
pigouts1037593pigouts
pilous84717753pilou_s
pious74621273pi_ou_s
pours74623183__pours
repours9310233repours
rigors72813713rigo_rs
rigour7258023rigour_
rimous8311913rimou_s
rumours976373rumours
sapours93610623sapours
savours10389343savours
scaurs85512053sca_urs
scours84913593_scours
siddurs934173siddurs
sieurs659043si_eurs
sours55230503__sours
stours65015633_stours
tabours94110093tabours
tenours72610073tenours
tours55325893__tours
tumours976753tumours
valours10248743valours
vapours12277463vapours
velours10278083velours
viators102712023viators
vigors102911483vigo_rs
vigour10256803vigour_
vinous93914173vinou_s
visors92912223viso_rs
vizors18328903vizo_rs
yours85217883__yours

Search took 7 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.390458182.1
2DLD Change Limit1340271406.22021547.7
3Display Results1401400.0463043.5
 (SQL Overall)1786911406.65626846.6
 
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.