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

89 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
volleying164376(None) 
colleting12311052colleting
collying14319542coll_ying
dollying13407412doll_ying
hollering1337742hollering
jollying19316052joll_ying
pollening1236922pollening
trolleying1442552trolleying
allaying12339303_allaying
alleging1038473_alleging
alloying12339143_alloying
allying113011663_all_ying
bellying14359073bell_ying
billeting1236633billeting
bogeying1575703bo_geying
bolling103820883boll__ing
bollixing1944813bollixing
bolloxing1944773bolloxing
boogeying1643623boogeying
bulleting1236643bulleting
bullying14329293bull_ying
collaging1337913collaging
collaring12310543collaring
collating12312763collating
collecting1548283collecting
colliding1338583colliding
colluding1335903colluding
conveying1838323conveying
cooeying1438143co_oeying
cullying14297503cull_ying
dallying13368493dall_ying
dolling93817373doll__ing
dolloping1344993dolloping
filleting1335843filleting
fleying14329873__fleying
following1665753following
fullering1336653fullering
gallerying1543033gallerying
galleting1137623galleting
gallying13328933gall_ying
gillying13306813gill_ying
gleying12318433__gleying
gullying13367243gull_ying
hollaing12167093holl_aing
holloaing1385793holloaing
holloing12148823holl_oing
hollooing1385363hollooing
hollowing1675933hollowing
honeying1537673ho_neying
hoseying1537193ho_seying
jellying19306173jell_ying
jockeying2663293jockeying
jollifying2443353jollifying
lolling83415773loll__ing
lolloping1244683lolloping
moldering1367863moldering
mollifying1944043mollifying
monkeying1944473monkeying
moseying1436853mo_seying
obeying1336543_o_beying
palleting1238733palleting
parleying1536113parleying
pelleting1237953pelleting
polling102920383poll__ing
polluting1235703polluting
rallying12289013rall_ying
rolling83620413roll__ing
sallying12309853sall_ying
soldering1169033soldering
sullying12328513sull_ying
tallying12318833tall_ying
tillering1037883tillering
toileting1036263toileting
tolling83418563toll__ing
trollying1354053troll_ying
valeting1238843v_aleting
vilifying1944493vilifying
villein1036753ville_in_
villeins1136043ville_ins
vogueing1332233vogue_ing
voling103918023vo_l__ing
volley12419743volley___
volleyed1543533volley_ed
volleyer1443163volley_er
volleyers1542773volleyers
volleys13316643volley__s
volplaning1642473volplaning
voluming1435043vo_luming
willying15306713will_ying

Search took 9 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.423422437.4
2DLD Change Limit148641897.57619620.0
3Display Results89890.0461934.8
 (SQL Overall)178691898.04522211.4
 
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.