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

69 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
ballasted124545(None) 
ballaster1145971ballaster
ballast9313992ballast__
ballasters1245092ballasters
ballasts1037932ballast_s
balloted1189042ball_oted
blasted104213472b__lasted
gallanted1145892gallanted
unballasted1451672unballasted
ablated102513443_abla_ted
alated75625143_a_la_ted
allayed11138063_alla_yed
allotted986873_allotted
allseed835953_all_seed
baccated15148373bacca_ted
backlashed22124283backlashed
backlisted1944503backlisted
badassed1244273ba_dassed
balanced1356513ba_lanced
balases93815433ba_las_es
baldpated1543823baldpated
ballad94315323balla___d
ballade104012563balla_de_
balladeer1243023balladeer
ballades114211643balla_des
ballasting1345283ballasting
balled94926893ball___ed
ballista1045803ballist_a
ballistae1143793ballistae
ballistic1346613ballistic
ballooned1245103ballooned
balloter1078893ball_oter
ballsier1036523ball_sier
ballute938543ball_ute_
ballutes1037523ball_utes
balsamed1344543balsa_med
baluster1037053ba_luster
basted95227233b___asted
beclasped1643743beclasped
belated103520013b_ela_ted
billeted1137643bill_eted
bilsted1038033b_il_sted
blaster94017303b__laster
blatted104812713b__latted
bleated104015973b_lea_ted
bloated104513433b_loa_ted
boasted104113743b__oasted
breasted1138823b_reasted
bullate93415073bulla_te_
bulleted1138393bull_eted
callused1135853callus_ed
collated113615063colla_ted
falcated1438473falca_ted
fellated1239563fella_ted
galeated104111573galea_ted
gallate83417123galla_te_
gallates92815523galla_tes
galleted1038213gall_eted
gallused1034193gallus_ed
lambasted14103253lambasted
lasted74323603___lasted
outlasted10128353outlasted
palleted1139863pall_eted
palliated1238493palliated
palmated132511003palma_ted
palpated13249763palpa_ted
tallaged10257923talla_ged
vallate103016563valla_te_
valuated12239203valua_ted

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.1731032896.0
2DLD Change Limit148641698.29617917.2
3Display Results69690.0332090.9
 (SQL Overall)178691698.50221017.5
 
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.