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

76 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
ballista104580(None) 
ballistae1143791ballistae
ballast9313992ballast_
ballasts1037932ballasts
ballistic1346612ballistic
barista9310812ba_rista
ableist9311773ableist_
ableists1036543ableists
alist56136783_a_list_
arista6415293_a_rista
baalism11310593baalis_m
baalisms1238033baalisms
backlist16910653backlist_
backlists17117413backlists
balata8614683ba_l_ata
baldest102313533baldest_
baldish1339503baldis_h
balkiest144112453balkiest_
balladist12146383balladist_
balladists13133823balladists
ballasted1245453ballasted
ballaster1145973ballaster
ballet84733973ball_et_
ballets93719513ball_ets
ballies93725743balli_es
balling104424763balli_ng
ballistics1444033ballistics
ballot84624093ball_ot_
ballots94116033ball_ots
balls76236413ball_s__
ballsier1036523ballsier
ballsiest1145413ballsiest_
ballsy11508873ball_s_y
ballute938543ball_ute
balmiest124110993balmiest_
balsa77920413ba_l_s_a
baptisia1245013baptisia
baptist11311873baptist_
baptists1236723baptists
baristas1039723ba_ristas
bassist9312743bassist_
bassists1037183bassists
batiste939743ba_tiste
biblist11310833biblist_
biblists1236873biblists
braillist1146193braillist_
braillists1263663braillists
bulliest104314503bulliest_
bullish12511193bullis_h
cellist9314423cellist_
cellists1038563cellists
diallist949553diallist_
diallists1056003diallists
galleta8399653gall_eta
gallica1047463galli_ca
galliot82214133galliot_
galliots9228683galliots
pallia83015593palli__a
palliate10311893palliate
palliest102814643palliest_
palmist112814343palmist_
palmists12268813palmists
phallist1338993phallist_
phallists1445723phallists
pollist9816603pollist_
pollists10910823pollists
rallyist1145363rallyist_
rallyists1243333rallyists
tallest7317093tallest_
tallis63319963tallis__
tallises82713263tallises
tallish103313583tallis_h
tallisim1074983tallisim
tallit63422733talli_t_
tallith102913063talli_th
tallits73215993talli_ts

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.513348325.5
2DLD Change Limit146162767.26620115.9
3Display Results76760.0302533.3
 (SQL Overall)178691767.80922882.7
 
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.