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

57 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
ghostlier134334(None) 
ghastlier1342891ghastlier
ghostier1235381ghost_ier
costlier1038522_costlier
ghostliest1453712ghostliest
ghostlike1743352ghostlike
gristlier1044282gristlier
hostler103411022_hostl_er
thistlier1243652thistlier
beastlier1144203beastlier
bristlier1144313bristlier
chestier1387423chest_ier
chortler13336843chortl_er
frostier1148163frost_ier
gasalier936443g_asalier
gaselier946973g_aselier
gasolier935833g_asolier
ghastliest1443443ghastliest
ghosted1236273ghost__ed
ghostiest1336543ghost_iest
ghosting1336463ghost_ing
ghostliness1542563ghostliness
ghostly14355103ghostl__y
ghostwriter1851513ghostwriter
ghoulie1144263gho_ulie_
ghoulies1235393gho_ulies
glossier9358203glos_sier
godlier938893g_o_dlier
gogglier1153923g_ogglier
goodlier1035793g_oodlier
goosier83512563goos__ier
goutier82612353g_out_ier
grislier935793gris_lier
grottier9316673gro_ttier
groutier9297173grout_ier
growlier1234883gro_wlier
growthier1642203growthier
gustier83813863g_ust_ier
hastier103916623_hast_ier
holier94921623_ho__lier
homelier1338983_homelier
hootier104915353_hoot_ier
hosier94219613_hos__ier
hosteler1137283_hosteler
hosteller1245863_hosteller
hostile10312553_hostile_
hostiles11312213_hostiles
hostlers113310483_hostl_ers
hotelier1137643_hotelier
hustler103410753_hustl_er
jostler14288223_jostl_er
motlier92010583_mo_tlier
ostler63312193__ostl_er
outlier72216143__outlier
portlier1038373_portlier
shoalier1137073sho_alier
whistler1496313whistl_er

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 Filter1786911486410.466383457.1
2DLD Change Limit148641577.01621186.0
3Display Results57570.0301900.0
 (SQL Overall)178691577.51223787.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.