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

187 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
laogai73598(None) 
laogais845811laogais
lagan66520342la_gan
lanai5319572la_nai
logan68123282l_ogan
logia68116602l_ogia
logoi69715942l_ogoi
aga410447233_a_ga_
again65218113_a_gain
agar58726413_a_gar
agas55938843_a_gas
alegar739283alegar
alga57927603_alga_
algae65319623_algae
algal66518213_algal
algas65624933_algas
alodia71112453alodia
aloha8513613aloha_
alohas9411703alohas
anga56831353_anga_
angas65827983_angas
argal65023383_argal
argali75013743_argali
assai5711543_assai
avgas96912133_avgas
banzai1737653banzai
baobab946403baobab
bargain1079063bargain
biogas94310913biogas
bogan87519003_bogan
brogan9311043brogan
dagga839543dagga_
daggas937973daggas
fanga96119623fanga_
fangas105017193fangas
gaga66625553ga_ga_
gardai839663gardai
hangar104114503hangar
hogan97817703_hogan
korai97018513_korai
laager74312783laager
laari54415713la_ari
labia75219003labia_
labial84714333labial
labra75415463labra_
lactam10310943lactam
lag47862123la_g__
lagans75717783la_gans
lager65132863la_ger
laggard10347623laggard
lagged95520133lagged
lagger85919833lagger
lagoon7410483lagoon
lags56546223la_g_s
lahar83114263la_har
laical8312323laical
laigh95515923laig_h
laighs10508803laighs
lallan63414173lallan
lama66635293la_ma_
lamas75532793la_mas
lamia75324323lamia_
lamiae84817453lamiae
lamias85020613lamias
lampad114510033lampad
lampas106615953lampas
lanais6316793la_nais
landau7310613landau
lang56637373lang__
langue71012173langue
languid936623languid
langur7109303langur
large65325463larg_e
larger74417513larger
larges74824233larges
largo65319783larg_o
largos74815063largos
lari45839153la__ri
lariat6629043lariat
larva8312483larva_
larvae938843larvae
larval948503larval
larvas9310233larvas
lascar868573lascar
lassi56316853la_ssi
lathi85417203la_thi
lati46438273la__ti
latria62313583latria
lauan55216793la_uan
laugh94414373laug_h
laughs10489023laughs
laura54116203laura_
laurae64011663laurae
lauras63414333lauras
lava76725423la_va_
lavage1038263lavage
lavas85422223la_vas
lawman11289053lawman
layman113511303layman
lazar144113643la_zar
lazuli1535363lazuli
legal65715943l_egal
ligan67920283l_igan
linga66820813linga_
lingam95112333lingam
lingas75116563lingas
litai55216363l_itai
load56730603l_o_ad
loaf76734903l_o_af
loam65630483l_o_am
loan47436453l_o_an
lobar7313013l_obar
loca65527683l_oca_
local74820273l_ocal
loci66126283l_o_ci
log46252683l_og__
logania847833l_ogania
logans76319063l_ogans
loge56837193l_og_e
loges66534203l_oges
loggia8457053l_oggia
loggie84011993l_oggie
loggy105714193l_oggy
logic88217833l_ogic
login66025003l_ogin
logjam1635363l_ogjam
logo57931763l_og_o
logon615922313l_ogon
logos67225333l_ogos
logs57343113l_og_s
logway1335913l_ogway
logy87025783l_og_y
longan75612363longan
loofa85912813loofa_
loofah12375813loofah
loofas9429833loofas
loral55927823l_oral
loran55925093l_oran
lota47233503l_ota_
lotah85315853l_otah
lotas55926303l_otas
loti46431833l_o_ti
lovat8321043l_ovat
loyal84513483l_oyal
lungan74710213lungan
lungi65516053lung_i
lungyi10525093lungyi
magi76329523ma_g_i
manga85026193manga_
mangas94122923mangas
margay12310593margay
naoi46024633nao__i
nilgai734873nilgai
ogam75120033__ogam
pagan86121163pa_gan
panga85323533panga_
pangas99921103pangas
plagal948573pla_gal
psoai7469923pso_ai
raga55930813ra_ga_
ragas65326063ra_gas
ragi56032283ra_g_i
saga55331173sa_ga_
sagas66025883sa_gas
saggar84010853saggar
saiga64717933saiga_
saigas74114293saigas
sanga66023793sanga_
sangar73617683sangar
sangas75222653sangas
shogi95013993shog_i
slogan7539223slogan
stoai55417863sto_ai
taiga64115653taiga_
taigas73712553taigas
tanga64923683tanga_
toga57027413_toga_
togae67020113_togae
togas67823003_togas
vagal94613633va_gal
vagi86719363va_g_i
wangan10311223wangan
yagi86922243ya_g_i
yoga87418053_yoga_
yogas96615603_yogas
yogi86120423_yog_i
zaikai1943713zaikai

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 Filter1786911127160.1731032896.0
2DLD Change Limit1127161876.73316740.8
3Display Results1871870.1261484.1
 (SQL Overall)1786911877.03225411.1
 
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.