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 “galliass” 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
galliass93542(None) 
galleass935051galleass
galliard10125752galliard
galliards1194542galliards
galliasses1173062galliasses
gallicas1136932gallicas
gallies84122712galli_es
galliots9228682galliots
galliums1145962galliums
galliwasp1541652galliwasp
galliwasps1651302galliwasps
palliasse1173022palliasse
alias55834603_a_lia_s
aliases7914493_a_liases
allays94313743_all_ays
allies63827673_alli_es
alliums957973_alliums
ballads104212913ball_ads
ballast9313993ball_ast
ballasts1037933ball_asts
ballies93725743balli_es
callans94518473call_ans
callas84526753call_a_s
callings113613833callings
dahlias1135723dahlia_s
dalliers93610613dalliers
dallies84023193dalli_es
fallals103310193fall_als
galabias1137733galabia_s
galahs105512683ga_l_ahs
galas65731643ga_l_a_s
galeas74618513ga_lea_s
galenas83310343galena_s
galilees936333galilees
galiots82311323ga_liots
gallant83517113gall_ant
gallants93310373gallants
gallate83417133gall_ate
gallates92815533gallates
galleasses1163013galleasses
galleins9258693galleins
galleons9258443galleons
gallerias1047133galleria_s
galletas9308133galletas
gallets83517403gall_ets
galleys11369713gall_eys
gallic9411643galli__c
gallica1047463galli_ca
gallican1155343gallican
gallicism1444283gallicism
gallicisms1543993gallicisms
gallied94115003galli_ed
galling93921963galli_ng
galliot82214133galli_ot
gallipot1145943gallipot
gallipots1243773gallipots
gallium1037943galli_um
gallivant1344503gallivant
gallivants1442613gallivants
gallnuts943923gallnuts
gallons83015953gall_ons
galloons9289703galloons
galloots9268963galloots
gallops103211653gall_ops
gallous82813953gall_ous
gallows113513513gall_ows
gallowses1374953gallowses
galls64729323gall___s
gallus74313203gall__us
galluses936963galluses
galyacs1335273ga_lyacs
galyaks1534623ga_lyaks
gambias125010733gambia_s
gapless10349993gapl_ess
garlics1038013garli_cs
gasless8319013gasl_ess
gavials1136603ga_vials
gillies84120963gilli_es
glass65518133g__l_ass
glias64618493g__lia_s
goalless935723goall_ess
gullies84717313gulli_es
hallahs133912463hall_ahs
halliard12125963halliard
halliards13104933halliards
halloas104318463halloa_s
hallways1745423hallways
kalians11310183ka_lians
kalmias1347973kalmia_s
lallans74113543lall_ans
mallings113413093mallings
pallia83015593pallia__
pallial92911253pallia_l
palliasses1283583palliasses
palliate10311893palliate
palliates11311033palliates
palliest102814643palliest
palliums1236703palliums
ralliers84010833ralliers
rallies73823343ralli_es
salliers83613343salliers
sallies73227813salli_es
salpians1036763salpians
salvias10279933salvia_s
tallgrass1042833tallgrass
talliers83711373talliers
tallies73624603talli_es
tallis63319963talli__s
tallises82713263tallises
tallish103313583talli_sh
talliths11377433talliths
tallits73215993talli_ts
tallness837103tallness
wallahs13409473wall_ahs
wallas95719393wall_a_s
wallies103320743walli_es

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621167.19020328.5
3Display Results1161160.0462521.7
 (SQL Overall)1786911167.67223291.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.